Creating a Stock Data Tracker with Buy/Sell Analysis

kohltonyork

New Member
Joined
Dec 29, 2020
Messages
10
Office Version
  1. 2019
Platform
  1. Windows
I have been working on an Excel Workbook that automatically pulls my friends paper trading data from thinkorswim.

The main problem I have run in to is I can pull the buys and I can pull the different selling points. The thing I can’t seem to do is link the two together.

I think I have an idea that will work. But I am not sure if it’s possible or how it would be possible. That’s where I need some help.

Let’s use Tesla as an example. (TSLA) let’s say I start with an initial position size of 1,000 shares. Bang. Tesla shoots up soon after buying it so I sell half of my shares. I’m down to 500 shares but my profit is large. Tesla dips back down and I decide the best move is to up my position as I believe it’s a dip. I buy 750 more shares leaving me with 1250. Then it rises again and I decide to close this position. Leaving me with 0 shares remaining, closing the trade.

This is what appears to be the best option for what I want, upon opening a trade keeping that trade open until the share count hits 0. And in that case it would keep this data separate from if I were to open another position on Tesla down the road.

Does this make sense and seem possible? If so I am more than open to any ideas on how I could get it working. Thank you much!
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,129,285
Messages
5,635,314
Members
416,852
Latest member
kanaikls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top