Stock to ETF(s)

Traderschool

New member
Does anyone know if it's possible to display a stock's ETF(s)?
If not, is it possible to upload a spreadsheet and then reference it? (I have a stock to major ETF (SPY/QQQ/DIA) and major sector ETF (XLK/XLY/XLF, et. al))
 
Solution
what resource do you use to list the stocks in an ETF?

i'm not sure what you wish to do.
you can make a list of symbols and import them to a watchlist. but a column study interacts with each symbol, in each row, separetely, it can't read values from other rows in the list.

a study can include other symbols and read price data for them. but the more you add, the longer formulas get when comparing values from all those variables.

if you want to have formulas interact with data from many symbols, it might be better to do in excel. i am not sure if there are limits to how many rtd formulas can be used in 1 file.

you could create an excel file,
..create a sheet for each ETF and the stocks you wish to monitor.
..pull in desired data with...
what resource do you use to list the stocks in an ETF?

i'm not sure what you wish to do.
you can make a list of symbols and import them to a watchlist. but a column study interacts with each symbol, in each row, separetely, it can't read values from other rows in the list.

a study can include other symbols and read price data for them. but the more you add, the longer formulas get when comparing values from all those variables.

if you want to have formulas interact with data from many symbols, it might be better to do in excel. i am not sure if there are limits to how many rtd formulas can be used in 1 file.

you could create an excel file,
..create a sheet for each ETF and the stocks you wish to monitor.
..pull in desired data with RTD() formulas.
..have 1 sheet setup as a summary page , a dashboard, to keep an eye on.

a post with links on using excel to pull in stock data.
https://usethinkscript.com/threads/...ters-in-my-market-watch-list.7988/#post-76614


i found this site that seems to list all the stocks in an ETF.
XLF , example
https://www.sectorspdr.com/sectorspdr/sector/xlf
11 etfs list at bottom page
pick one.
click on portfolio , in row of gray buttons
https://www.sectorspdr.com/sectorspdr/sector/xlf/portfolio
lists 10 stocks per page. can click next to see more.
 
Solution

Join useThinkScript to post your question to a community of 21,000+ developers and traders.

Similar threads

Not the exact question you're looking for?

Start a new thread and receive assistance from our community.

87k+ Posts
285 Online
Create Post

Similar threads

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.
Back
Top