Is the historical database from quantshare truly inaccurate, or have I imported the wrong datasets somehow?
I just used a quantshare link (http://www.quantshare.com/item-151-advancing-declining-unchanged-volume-for-nyse-amex-and-nasdaq) to download a
historical database of advancing, declining, and unchanged market volumes for major US markets. After doing so, I manually spot checked a few dates
for NYSE advancing volume - specifically, yesterday's date 21-April-2010 and some others, 01-May-2007, and 02-April-2009 at random.
I found that although yesterday's data matched other reported sources for advancing volume, data for the older dates did NOT match. My sources for spot
checking the data are these 2 sites for 02-April-2009:
The website was using Integer type to store volume. The problem is that if that integer cannot contain values higher than (2147483647). This is why you see a lot of (2147483647). However, it appears that the website no longer uses Integer (You can see that now there are values higher than 2147483647).
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.