Oct 06 2019 11:22 AM - edited Oct 06 2019 11:26 AM
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-19 | 1:40:20 PM | B | 20 | 2881 |
2-Oct-19 | 1:40:25 PM | B | 20 | 2881 |
2-Oct-19 | 1:41:28 PM | B | 10 | 2881 |
2-Oct-19 | 1:48:38 PM | B | 20 | 2880.25 |
2-Oct-19 | 1:49:35 PM | B | 25 | 2879.25 |
2-Oct-19 | 1:50:54 PM | S | -20 | 2878.5 |
2-Oct-19 | 1:53:29 PM | S | -25 | 2879 |
2-Oct-19 | 1:53:35 PM | S | -25 | 2879.25 |
2-Oct-19 | 1:57:27 PM | S | -10 | 2880.75 |
2-Oct-19 | 1:58:51 PM | B | 25 | 2880.75 |
2-Oct-19 | 1:59:53 PM | B | 25 | 2881 |
2-Oct-19 | 2:00:03 PM | B | 25 | 2880.25 |
2-Oct-19 | 2:00:13 PM | S | -25 | 2880.75 |
2-Oct-19 | 2:00:31 PM | B | 25 | 2880 |
2-Oct-19 | 2:00:58 PM | B | 25 | 2879.5 |
2-Oct-19 | 2:02:26 PM | B | 25 | 2879 |
2-Oct-19 | 2:03:01 PM | B | 25 | 2878.5 |
2-Oct-19 | 2:03:01 PM | B | 25 | 2878.5 |
2-Oct-19 | 2:03:02 PM | B | 25 | 2878.25 |
2-Oct-19 | 2:03:29 PM | S | -25 | 2879.75 |
2-Oct-19 | 2:03:51 PM | S | -25 | 2880.5 |
2-Oct-19 | 2:04:05 PM | S | -25 | 2881.25 |
2-Oct-19 | 2:06:03 PM | B | 25 | 2882 |
2-Oct-19 | 2:06:05 PM | B | 25 | 2882 |
2-Oct-19 | 2:06:10 PM | B | 16 | 2881.75 |
2-Oct-19 | 2:07:08 PM | B | 25 | 2881 |
2-Oct-19 | 2:07:09 PM | B | 25 | 2880.75 |
2-Oct-19 | 2:07:09 PM | B | 25 | 2880.75 |
2-Oct-19 | 2:08:23 PM | S | -25 | 2882.5 |