Exporting Scan Results to a TradingView Watchlist
I was asked earlier today about how to export a list of stocks from a SwingTradeBot scan result into a TradingView Watchlist. That reminded me that I forgot to write about an enhancement that I added last summer.
In response to another TradingView watchlist request I added another column (called tradingview_symbol) to SwingTradeBot's CSV file exports. That column contains TradingView's ticker symbol. TradingView combines the stock symbol with the stock's listing exchange, so AAPL, which is listed on the Nasdaq would be NASDAQ:AAPL. So that column of data will look something like:
NASDAQ:SRPT NASDAQ:VGIT NYSE:AWF AMEX:BKLN NYSE:BMY
From what I can tell, TradingView can import a text file of those symbols into a watchlist. So here's how you can get a list of symbols from SwingTradeBot to TradingView:
- Download / export a CSV from SwingTradeBot
- Open that file in a spreadsheet program. (Microsoft Excel, Apple Numbers, Google Spreadsheets, LibreOffice Calc, etc.)
- Copy all the data from the tradingview_symbol column
- Paste that copied text into a new text file (or you could delete all the other columns in the original CSV)
- Import that new file, which should only contain the TradingView-formatted symbols into a TradingView watchlist.
Importing into Other Systems
You could do something similar if you have a system that takes a comma-delimited list of symbols. A simple spreadsheet formula can help you transform the data:
- Download / export a CSV from SwingTradeBot
- Open that file in a spreadsheet program (Microsoft Excel, Apple Numbers, Google Spreadsheets, LibreOffice Calc, etc.)
- Create a formula to transform the column of data you want either symbol or tradingview_symbol
- Copy the result of that formula
Here's an example of a Google Spreadsheet with such a formula. In this case, the symbols are in column A and the formula to use is:
=JOIN(",", A1:A1000)
Using the same sample data from above would give you: NASDAQ:SRPT,NASDAQ:VGIT,NYSE:AWF,AMEX:BKLN,NYSE:BMY
You could do something similar in Excel with TextJoin and there should be similar functions in other spreadsheets.
Recent Comments
- TRTCryptoCraig on Bad Quotes for 28 May...
- TraderMike on Bad Quotes for 28 May...
- TraderMike on Market Recap for Friday, May 31, 2024
- PleasantTurtle699 on Market Recap for Friday, May 31, 2024
- TraderMike on Market Recap for Friday, May 31, 2024
From the Blog
Featured Articles