Home

Net Position Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-895799%22%20slang%3D%22en-US%22%3ENet%20Position%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895799%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHey%20Yall%2C%20I%20am%20trying%20to%20build%20a%20chart%20that%20measures%20my%20net%20position%20overtime%20for%20investment%20purposes.%20How%20would%20I%20go%20about%20doing%20this%3F%20I%20have%20a%20time%20column%20and%20how%20many%20I%20buy%2Fsold%20on%20another%20row.%20I%20think%20it%20is%20reading%20it%20as%20each%20buy%20or%20sell%20as%20that%20number%20instead%20of%20adding%20or%20subtracting%20from%20the%20previous%20position.%20How%20would%20I%20do%20it%3F%20Sample%20data%3A%20(I%20need%20it%20to%20look%20like%20that%20doesnt%20have%20the%20data%20beside%20it)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESample%20data%3A%3C%2FSPAN%3E%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A40%3A20%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E2881%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A40%3A25%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E2881%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A41%3A28%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E2881%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A48%3A38%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E2880.25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A49%3A35%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2879.25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A50%3A54%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-20%3C%2FTD%3E%3CTD%3E2878.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A53%3A29%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-25%3C%2FTD%3E%3CTD%3E2879%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A53%3A35%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-25%3C%2FTD%3E%3CTD%3E2879.25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A57%3A27%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-10%3C%2FTD%3E%3CTD%3E2880.75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A58%3A51%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2880.75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E1%3A59%3A53%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2881%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A00%3A03%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2880.25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A00%3A13%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-25%3C%2FTD%3E%3CTD%3E2880.75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A00%3A31%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2880%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A00%3A58%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2879.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A02%3A26%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2879%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A03%3A01%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2878.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A03%3A01%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2878.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A03%3A02%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2878.25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A03%3A29%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-25%3C%2FTD%3E%3CTD%3E2879.75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A03%3A51%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-25%3C%2FTD%3E%3CTD%3E2880.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A04%3A05%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-25%3C%2FTD%3E%3CTD%3E2881.25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A06%3A03%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2882%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A06%3A05%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2882%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A06%3A10%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3CTD%3E2881.75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A07%3A08%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2881%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A07%3A09%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2880.75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A07%3A09%20PM%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E2880.75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2-Oct-19%3C%2FTD%3E%3CTD%3E2%3A08%3A23%20PM%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3CTD%3E-25%3C%2FTD%3E%3CTD%3E2882.5%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-895799%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
chughes499
Occasional Visitor

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
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies