+ Reply to Thread
Results 1 to 2 of 2

Net Position Chart

  1. #1
    Registered User
    Join Date
    10-06-2019
    Location
    Atlanta, USA
    MS-Off Ver
    Georgia
    Posts
    1

    Net Position Chart

    Hey Yall, I am trying to build a chart that measures my net position overtime for investment purposes. How would I go about doing this? I have a time column and how many I buy/sold on another row. I think it is reading it as each buy or sell as that number instead of adding or subtracting from the previous position. How would I do it?
    Sample of data:

    1:40:20 PM B 20
    2:40:20 PM B 20
    3:40:20 PM B 10
    4:40:20 PM B 20
    5:40:20 PM B 25
    6:40:20 PM S -20
    7:40:20 PM S -25
    8:40:20 PM S -25
    9:40:20 PM S -10
    10:40:20 PM B 25
    11:40:20 PM B 25
    12:40:20 AM B 25
    1:40:20 AM S -25
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,033

    Re: Net Position Chart

    Excel's charts do not really do any analysis. If you want a chart that will show "cumulative running total", you will need a column in the spreadsheet that calculates the cumulative running total. From you picture and text, I am not sure exactly how you are keeping track of running total. Maybe something like =F2+C3 (assuming your cumulative total is in column F and the quantity bought/sold is in column C). Then use the cumulative running total figures for the chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] can I fix the position of a chart on a sheet
    By Trebor777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2017, 11:21 AM
  2. Set position of chart
    By gclode in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2015, 05:05 PM
  3. how to add a text box to a chart position it ?
    By 77anders in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-17-2009, 09:37 AM
  4. [SOLVED] ???How to set chart position
    By Jaylin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2006, 02:55 AM
  5. How to set the chart position exactly?
    By ramkumar_cpt in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2006, 09:30 AM
  6. [SOLVED] Chart Datalabels.Position
    By Michael Singmin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2005, 03:15 PM
  7. Changing chart title changes position of chart
    By Bing in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2005, 05:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1