Accessing Quandl data via API
Clients can import data via the Quandl API directly into Optuma. Quandl provides over 300 databases (many free) containing global financial and economic data. Enterprise Services clients can connect to Quandl automatically, but Trader and Professional Services clients must add the Quandl access option to their subscription.
The data import can be done on a symbol-by-symbol basis, or for an entire exchange. Click this image for more information and to create a free Quandl account and API key.
To setup Quandl data in Optuma you will need your Quandl Username and API key. Once you have created a Quandl account click on your Account Settings to access your API key:
1. To setup Quandl data in Optuma, ensure all charts are closed, click the Data menu and select Configure Data Providers.
2. In the window that opens select Quandl and click Next.
3. Enter in your Quandl username and copy and paste your API key.
4. Click Next without adding any exchanges to the right-hand side.
5. Restart Optuma, if the connection has been successful the Data menu will display green text. When you hover over the Data menu you should see a tip window with the text "Quandl Connected".
6. Press F3 to open the Data Selector and right-click on a blank area of the left-hand side window. In the menu that displays select Add Custom Exchange
7. In the window that displays, type the name of the Exchange, and select Quandl as the Data Provider. A new field will display called Database, from which you can click to select the Quandl Database you wish to import, such as free Blockchain data.
Note: Depending on the size of the database, the import process can take a long time (10+ minutes).
Once the exchange has been imported you will be able to open charts sourced from the database on Quandl, appearing under the name of the exchange selected above.
Adding Individual Quandl Codes
You can open charts for individual Quandl codes instead of importing a complete exchange. Search the Quandl website to find the database and symbol you wish to download e.g. UK GDP from the Office of National Statistics. In the top-right corner of the screen you will see the Quandl code:
Once Quandl data has been set up in Optuma you can then enter the Quandl symbol directly into the data selector. The syntax to automatically add the Quandl code is QDL:[DATABASE]/[SYMBOL]. In the zinc example above:
It will take 5 to 10 seconds for the code to be added, but when it appears in the security selection list double-click to open the chart.
- By default Optuma will request 10 years of historical data. To increase this, select the exchange from Data > Exchanges menu and select the End of Day Data Options to increase the history:
- The first time you open a new chart from a Quandl code in Optuma, the full historical data will download automatically. After that, the chart will update with new data each time the chart is opened (Data on Demand). As such, Quandl data is not suited for use in daily scanning - unless the charts have been opened first to download the data.