Dear all,

We are currently developing a new Data Download tool and are looking for testers. On release, this will be for 'Active' and above subscription levels.

If you are interested please click here.

Your comments and suggestions are welcome.

Karl.

Karl - glad you spotted it.
I've no idea how the creation time is managed, but 6pm would be great. Fits in with others.
If you managed to include the USA numbers that'll be good, but I guess that would create the problem of having to include them after 9pm. What about a separate download file?

BT,

Will pass your comments onto Karl.

Ian

I would agree with BT, 6pm would be ideal !

I have taken a look at tonight's data.

Although the 'Easy Downloads' hints at data being in the format 'OHLCV' (which if I am not mistaken is pretty much a standard format for EOD downloads) the Easy Download files actually contain data in the format HLOCV.

There appears to be a problem with stocks that have not traded/moved during the day.

Take ASF as just one example - the High and Low are given as zero.

Seems to be 3 points then:
1) 6pm data preparation. (most people will do "homework" before 11pm, not after).
2) Column order to be "as on the tin"
3) Non-traded stocks to have the Open price as the High/Low. I even saw some with a volume but no H/L, so I guess it's better to check for zero in the H/L and substitute the Open price.

BT,

Thanks for the feedback,

Ian

Righty-o

1) We are still trying to sort getting the close data a little earlier for you all. But hope to get something sorted quite soon.

2) I'll change the Column order. Would there be any need to be able to choose which order the columns come in or would OHLCV be ok?

3) I'll change "High" and "Low" both to be set to "Open" if they are zero. That ok?

4) As mentioned in the Investors room, I'll add a sort by option.

K.

I've checked the data and if the High and Low are blank:

a) Set the "High" to either "Open" or "Close" depending on which is higher
b) Set the "Low" to either "Open" or "Close" depending on which is lower.

K.

Karl,

Can't see any reason to allow options for column incl/excl/order, as if the "standard" is used then it loads into everything as expected and can be processed as each person desires.

The Column Sort option should default to EPIC with everything else being the options imo. Reason being that almost evey cross-reference or search will be on the Epic.

The High,Low problem has been fixed.

The default order has been changed to OHLCV.

The sort option has now been added, with Epic being the default.

We have also managed to change the close time to 7pm.

K.

Quick update ...

The update time has to be moved back to 11pm for the moment. We tried it at 7pm yesterday but this caused problems in the portfolio. We are trying to find another way to get the data for you at an earlier time.

K

TTT.

I'd like some help on this please. The data all seems to be enclosed within speech marks ("). How can I save this as a csv file without all the speech marks?

Hil,

I will get Karl to post here in a few moments.

Ian

Hilary,

The standard CSV format allows the inclusion of speech marks (") to help delineate the data. For example if one section of data included a comma but it was not to be used as a data seperator.

The data will load seemlessly into all the spreadsheet software that I have tested it with (inc Microsoft Excel, OpenOffice Spreadsheet).

If the speech marks are causing problems for you loading the data into some other software please let me know and I will create an option to switch them off.

Hope that helps,

K

Karl: any news about making the download available earlier than 11pm - I'm tucked up in bed by then.. :)

BT,

He has just popped out for lunch - I will get him to answer your question when he returns.

Ian

Karl, Ian,

Thanks for your help. I'm probably doing something wrong here.

I'm downloading the ohlcv data for the previous day which produces a spreadsheet within my browser. I'm then clicking "File", then "Save as" and have saved as both a CSV file and an Excel file. I've then tried opening the files within both Excel and Lotus 1-2-3 and they still have the speech marks. They're certainly not seamless. Help please??!!??

Hilary,

Do you get a choice to open the file or save it when you click the download?
What browser are you using?
What spreadsheet do you use as your default?
When the file loads into your browser does it have the speech marks?

I'm sure we will sort this problem out for you :)

K

hilary - when you go to the download page, you will notice it is defaulted to csv just click download at bottom of page then save it to your pc you can then import it into your excel spreadsheet.

Karl,

Normally when I download a file, I get a choice of saving it or opening it. With your download, I don't get a choice and it just opens in my browser (IE6). It has the speech marks within the browser. I then have to save it from the browser.

CSV files are defaulted to open within 1-2-3 (which I happen to prefer over Excel) although I have tried opening it with Excel but to no avail.

Karl,

I've a copy of your CSV file open (in Excel) atm. The date, epic, name and ohlcv data is all contained within the cells of column A and hasn't separated into the other columns at all. It has, however, separated into the respective rows.