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.

Ok ... think we have sorted the problem ...

The Update doesn't happen at 7pm as previously thought, it happens around 11pm. We will look into changing this for to an earlier time if possible or create some workaround.

As for the prices themself ... they are all ok ... The prices were different to the benchmark as they were the prices for the 18/08/2004. The Data for the 19/08/2004 is all correct.

ie.
Date Close High Low Open Vol
18/08/2004 165.75 167.50 159.50 167.50 5,172,144
19/08/2004 167.00 169.75 165.00 169.75 7,089,537

The Date shown by the "Easy Download" will change once the process for collecting the end of day prices has finished.

BrianTrayda ... They are all FTSE indices so are available in the download.

I'll have a look at our data and see if we can add some other foriegn indices :)

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.