Net Position Chart

Copper Contributor

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 data: (I need it to look like that doesnt have the data beside it)

 

Sample data:

2-Oct-191:40:20 PMB202881
2-Oct-191:40:25 PMB202881
2-Oct-191:41:28 PMB102881
2-Oct-191:48:38 PMB202880.25
2-Oct-191:49:35 PMB252879.25
2-Oct-191:50:54 PMS-202878.5
2-Oct-191:53:29 PMS-252879
2-Oct-191:53:35 PMS-252879.25
2-Oct-191:57:27 PMS-102880.75
2-Oct-191:58:51 PMB252880.75
2-Oct-191:59:53 PMB252881
2-Oct-192:00:03 PMB252880.25
2-Oct-192:00:13 PMS-252880.75
2-Oct-192:00:31 PMB252880
2-Oct-192:00:58 PMB252879.5
2-Oct-192:02:26 PMB252879
2-Oct-192:03:01 PMB252878.5
2-Oct-192:03:01 PMB252878.5
2-Oct-192:03:02 PMB252878.25
2-Oct-192:03:29 PMS-252879.75
2-Oct-192:03:51 PMS-252880.5
2-Oct-192:04:05 PMS-252881.25
2-Oct-192:06:03 PMB252882
2-Oct-192:06:05 PMB252882
2-Oct-192:06:10 PMB162881.75
2-Oct-192:07:08 PMB252881
2-Oct-192:07:09 PMB252880.75
2-Oct-192:07:09 PMB252880.75
2-Oct-192:08:23 PMS-252882.5
0 Replies