This is a trading object shared by a member. You can use this object as well as hundreds of others with QuantShare - Trading Software.
Click on the Like button or on one of the share buttons to share this object and spread the word about QuantShare.
QuantShare is an advanced trading software for stock, forex, futures, ETF and options markets. It is the best and the most complete EOD trading software software and it is FREE (beta version).
This is an item for UK stock traders that need historical quotes data. The end-of-day historical data is downloaded from Google for 2867 ticker symbols. The symbol list (Stocks that are listed in the London Stock Exchange) can be downloaded at the following location: LSE Symbols. You can choose the start and end date or let the item detect the last quote date for each symbol and automatically adjust the 'from' date.
The item implements the three types of script available in download items.
The first script, which is a URL-Script, is used to build the URL needed in order to get the data.
The second script is a Pre-Script; its role is to transform the date contained in the CSV data to an understandable date value. For example, it transforms the following date: 01-Dec-2009 to 01-12-2009.
The third and last script is a Post-Script, and it is used to correct some errors in the data. It detects whether the high, low or open value is equal to zero (errors in the downloaded historical data) and then updates these fields and assigns them the close price value.