open profit watchlist column using input variables


Category:
0
0

I’d like to create an “open profit” column on a watchlist of symbols for a non-TOS investment account i have.  I’m wondering how i can create a column that uses input variables to the effect of:

IF symbol = AAPL (an input value)

THEN open profit = (current price of the symbol) * (the number of shares i own as an input value)

 

any ideas?

Marked as spam
Posted by (Questions: 6, Answers: 5)
Asked on February 12, 2021 12:00 pm
72 views
0
Private answer

The code you enter code in a custom watchlist column will apply to every ticker applied to that watchlist. One set of code works the same for all of them.

When I attempted to find a solution to this the code failed to work correctly. I do not believe there is a solution that works in a watchlist on Thinkorswim. So you will need to use the RTD() function in Excel to build your watchlist in an Excel spreadsheet. (this only works for the Windows version of Thinkorswim)

Details on how to use the RTD() function in Excel to get live data from Thinkorswim are explained in the following video:

https://www.hahn-tech.com/thinkorswim-rtd-excel/

 

Marked as spam
Posted by (Questions: 37, Answers: 4086)
Answered on February 12, 2021 1:03 pm