Custom data in watchlist column

chato17

New member
Hi- just getting started with ThinkScript and this is definitely beyond my knowledge base. I searched, but couldn't find anything close. Here's my use case:

I have data that I generate daily in Excel by ticker. I cannot create this data within ToS as the inputs to this data aren't available in ToS. Ideally, I want to copy and paste this data into the ThinkScript editor. In the watchlist column, any time that a ticker matches the ticker pasted into the editor, I want to display that data in a watch list column.

Here's an example:

1. I generate in 2 columns (ticker and score, respectively) of data in excel as follows:
AAPL 1.2
GOOGL 3.1
MSFT 7.5
TSLA 12.5
XOM 4.5
CRM 15.3
BAC 15.2
WFC 32.3

2. I want to paste this data into the editor, along with the script you create. Ideally, I can just paste this data.

3. I have watchlists created for sectors, like Banks and Tech.

3.1. In my Bank watchlist, I would see data as follows:
BAC 15.2
STI -
WFC 32.3

3.2. In my Tech Watchlist, I would see data as follows:
AAPL 1.2
FB -
GOOGL 3.1
MSFT 7.5
TSLA 12.5

If you can think of a more elegant solution, I am open. Thanks so much. Have learned a lot here!
 

miles

New member
I'm wanting to pull data from excel into some ToS code... when I google it, the only thing I can find is exporting data from ToS into excel. The excel sheet updates once daily.

Is this possible to do with ToS?
 

miles

New member
I apologize, I should have been more specific.

I have an excel sheet that updates daily.. the code needs to pull values from those dates. What I don't want to do is go in and manually have to shift everything down one day to maintain the code. I'd rather have ToS pull from the excel sheet and replace one value with another assigned value. If that makes sense at all.

I guess maybe worst case scenario I could modify the excel sheet somehow to make it copy/paste into ToS.

I'm shocked this isn't an option though.
 

iTrade2

New member
Anybody know how to setup that when I click on a symbols from excel it will link back to the TOS chart?
Please take a look at the picture; these symbols are real time quotes that I scanned then exported from TOS to Excel earlier.
Thanks!

3wfjPsg.jpg
 

Similar threads

The Market Trading Game Changer

Join 2,500+ subscribers inside the useThinkScript VIP Membership Club
  • Exclusive indicators
  • Proven strategies & setups
  • Private Discord community
  • ‘Buy The Dip’ signal alerts
  • Exclusive members-only content
  • Add-ons and resources
  • 1 full year of unlimited support

Frequently Asked Questions

What is useThinkScript?

useThinkScript is the #1 community of stock market investors using indicators and other tools to power their trading strategies. Traders of all skill levels use our forums to learn about scripting and indicators, help each other, and discover new ways to gain an edge in the markets.

How do I get started?

We get it. Our forum can be intimidating, if not overwhelming. With thousands of topics, tens of thousands of posts, our community has created an incredibly deep knowledge base for stock traders. No one can ever exhaust every resource provided on our site.

If you are new, or just looking for guidance, here are some helpful links to get you started.

What are the benefits of VIP Membership?
VIP members get exclusive access to these proven and tested premium indicators: Buy the Dip, Advanced Market Moves 2.0, Take Profit, and Volatility Trading Range. In addition, VIP members get access to over 50 VIP-only custom indicators, add-ons, and strategies, private VIP-only forums, private Discord channel to discuss trades and strategies in real-time, customer support, trade alerts, and much more. Learn all about VIP membership here.
How can I access the premium indicators?
To access the premium indicators, which are plug and play ready, sign up for VIP membership here.
Top