TradingView integrates Quandl — Best Web Charting Meets 9 Million Datasets!
We are super happy to announce a deep integration of TradingView with Quandl! Quandl is an open data platform which provides access to over 9 million free datasets. This awesome development is unique because it opens unprecedented horizons in online market analysis!
Quandl doesn’t provide real-time or intraday price data, but has a HUGE amount of statistical and economic data from all over the world.
- Short Interest & Bullish/Bearish Sentiment Index data for stocks. Now you can add these metrics right to your chart, just like an indicator.
- Fundamental Fields from SEC and Damodaran — right on your chart.
- Commitment of Traders (COT) value for futures contracts (provided by CFTC).
- International Stocks.
- Thousands of Economics & Social Data fields from all over the world!
Basically, you can now visualize ANY data that Quandl has right on TradingView! Even more awesome, you can host your data with Quandl, and then it will appear for analysis on TradingView charts!
How it works:
You can add datasets from Quandl to the TradingView chart in two ways:
- As a symbol series.
- As a study using Pine script.
Method 1 — Adding Quandl data as a symbol series
The first option is best if you want to plot bars for symbols that are not available on TradingView. For example, you want to see EOD/AAPL, and TradingView doesn’t have it yet. Follow these steps:
- Find EOD/AAPL on Quandl.com and open it.
- Note the “Quandle Code” in the top right corner.
- Copy & paste it into the Symbol Edit on TradingView using ‘QUANDL:’ prefix. You will end up with a line like this: QUANDL:EOD/AAPL.
- Press Enter.
Now you have a EOD/AAPL chart on TradingView! You can add any data series to the chart in the same fashion. It doesn’t have to be price data, it can, for example, be the orange production in Brazil.
You can also add any data series from Quandl as a second symbol to the chart by using Add/Compare. For example, EOD/AAPL will look like this:
Or it can be the Unemployment Rate in California:
NOTE: Keep in mind that many Quandl datasets contain more than one data series, for example http://www.quandl.com/ISE/IND_S. To request the required data series, you’ll need to add its number after a ‘|’ delimiter to your request. For example, to get the ‘10 avg’ column from ISE Sentiment Index, use ‘QUANDL:ISE/IND_SI|1’. If you don’t specify that parameter, then the first data series from the dataset will be used.
Method 2 — Adding Quandl data as a Pine script study
Let’s say you are looking at a chart of Apple (AAPL stock). You can easily add any fundamental data from this page, or something like the Short Interest to your chart by using the QUANDL study, or the Commitments of Traders (COT).
How to Effectively Use Quandl Data with Pine Script
TradingView’s Pine lets you request data from Quandl right from your scripts. You can then manipulate that data however you want.
For example, some data (like Dividends, or Short Interest) always refers to a particular stock. So, to avoid manually re-requesting data for each new symbol that you view (looking up the quandl code, adding it to your chart, etc.), you can automate the process.
Solution: you can make your study automatically request appropriate data based on the symbol that’s currently on your chart. We made a couple of examples,such as the Pine Short Interest script. If you add this study to a chart, it will display the Short Interest for whatever symbol that you have on the chart.
You can write a similar “syncing” studies for any other data set that interests you, such as the Commitment of Traders value for futures. The possibilities and combinations in which you can use the data are limitless!
All studies mentioned above are in open access in the public library, and you are welcome to share yours with the community!
NOTE: Use the following function to reference datasets from Quandl:
// with default mapping (OHLCV will be auto mapped if they exists) quandl(code) => security("QUANDL:" + code, “D”, close) // explicitly specify column to return quandl(code, column) => security("QUANDL:" + code + “|” + to_string(column), “D”, close)
Quandl contains TONS of data from different areas of expertise, all of which can be easily requested from Pine scripts. This opens completely new and exciting ways to analyze financial markets!