Export scan results to TradingView watch list
Earlier today, someone asked me how to export the stock list in the scan results of SwingTradeBot to the TradingView watch list. It reminds me that I forgot to write about the enhancements that I added last summer.
Respond to another TradingView watchlist request I added another column (called tradingview_symbol) to the CSV file export of SwingTradeBot. This column contains TradingView’s stock code. TradingView combines the stock code with the stock exchange, so the AAPL listed on NASDAQ will be NASDAQ:AAPL. So that column of data looks like:
Nasdaq Stock Code: SRPT Nasdaq Stock Code: VGIT New York Stock Exchange: AWF American Express: BKLN New York Stock Exchange: BMY
As far as I know, TradingView can import text files of these trading instruments into the watch list. Therefore, you can get the list of trading instruments from SwingTradeBot to TradingView through the following methods:
- Download/export CSV from SwingTradeBot
- Open the file in a spreadsheet program. (Microsoft Excel, Apple Numbers, Google Spreadsheet, LibreOffice Calc, etc.)
- Copy all data from Tradingview_symbol column
- Paste the copied text into a new text file (or you can delete all other columns in the original CSV)
- Import that new file, It should only include trading instruments in TradingView format into the TradingView watch list.
Import other systems
If your system uses a comma-separated list of symbols, you can do something similar. A simple spreadsheet formula can help you transform the data:
- Download/export CSV from SwingTradeBot
- Open the file in a spreadsheet program (Microsoft Excel, Apple Numbers, Google Spreadsheets, LibreOffice Calc, etc.)
- Create a formula to convert the data column of the symbol or trading view you want to trade
- Copy the result of this formula
This is an example of a Google spreadsheet with this type of formulaIn this case, the symbol is in column A, and the formula to be used is:
=Join(“,”, A1: A1000)
Using the same sample data above will provide you with: NASDAQ:SRPT, NASDAQ:VGIT, NYSE:AWF, AMEX:BKLN, NYSE:BMY
You can do something like Use TextJoin in Excel Similar functions should be available in other spreadsheets.