Click here to Login Universal Downloader

by Jim Harrison, 2436 days ago
Share |

NOTE: Updated 01/25/2014. See Note 3 below. Thanks to Zoidberg, many thanks.

This EOD(end of day data, no intraday data) downloader can be used to download all data sets from the website. They have more than 8 million global data sets available, so get busy!

Visit for complete listing for your country. Visit to see all the sources for the data. Quite impressive. Visit for sample spreadsheets and the nomenclature used by Quandl.

IMPORTANT: This downloader uses the Name3 field to get the ticker from your quantshare database, so be sure to place the Quandl symbol in the name3 field or change to accommodate your dataset.

Quandl Symbology can be found below using the following nomenclature: SOURCE/EXCHANGE_TICKER as the entire ticker symbol. So, to get historical data for IBM stock, the symbol to use in the Name3 field would be GOOG/NYSE_IBM A real easy way to troubleshoot your symbols is to add it to the end of the URL and get the visual, along with all details for that symbol. Helps with esoteric datasets as well. Continuing with IBM as the sample, the URL to test your symbol would be

Further Examples of symbols:

Stock Data: 60+ Worldwide Exchanges

World Indices: 85+ Indices

Global Economic Data:

Continuous Contract Commodities and Futures Data Examples: All World Markets

Forex Data Examples: 134 pairs available

Bitcoin rates: All Currencies

Bitcoin Stats:
BCHAIN/TOTBC (total coins)

Note1: Most Econ series and "other" series like M2 Money Supply (FRED/BASE) only have DATE and VALUE, so make sure to check the parser to align VALUE with CLOSE for ease of use, else all the data ends up in the open field.

Note 2: You will need to register on the site or use your twitter account to get an API Auth_Token. Once logged into Quandl, navigate to: >your account> API tab for your personal token. Once you have the auth_token, return to the Download Manager inside Quantshare, select the Universal Downloader then click Update at the top and to add your auth_token to the URL string in order to get the full benefit. Example of URL string for downloader with auth_token added:[SYMBOL].csv?&auth_token=XXXXXXXXXXXXXXXXXXXXX&trim_start=[2Y]-[2M2]-[2D2]&trim_end=[Y]-[M2]-[D2]

Note3: Downloader updated on 01/25/2014 to include a post script that replaces errant 0 values found in the Open, High or Low columns with the close price if it is not equal to 0. (If you prefer to not "scrub" the datasets, simply update the downloader and remove the POST script from the parser)

FYI: I ended up with three variations of this downloader to accommodate my needs by copying the item 3 times, and making slight adjustments to the field mapping.

Share This ->
Share |

You have to log in to bookmark this object
What is this?

Type: Download Script

Object ID: 1404


Market: All


You must log in first

Join now
and get instant access for free to the trading software, the Sharing server and the Social network website.
Click here

Related objects


Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object

Technical Analysis

Fundamental Analysis

Random Blog Posts

Troubleshooting a Trading System

Backtesting All Candlestick Patterns in 10 Minutes

Real Time Alerts: Support and Resistance Lines Breakout

Custom Shortcuts - Move a Chart to Display the Last Quotes/Data

Export Trading Orders from a Portfolio to a File

Backtesting Your Trading Systems: Symbol Segmentation

Update Chart Layout based on Active Time Frame

Presentation of QuantShare's new Real Time Version

Show All

Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object

Create an account
Affiliate Program
Contact Us
Trading Forum
How-to Lessons
About Us
Terms of Use

Copyright 2023
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Follow us on Google+
RSS Trading Items

Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.