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.

hilary, are you happy with the default spreadsheet when called from IE being Excel rather than 1-2-3? If you reinstall Excel that should happen I think and the CSV file should then open fine.

K.,

I did actually install Excel after 1-2-3. Is there any way of telling which spreadsheet IE is using?

Uhm, well, if you click on the MoneyAM's button you say you get 1-2-3, so that's what it's using!

I assumed the last installed would take precedence. The other way of fixing it would be to go into the registry, but I don't know if you're comfortable with that.

I've set CSV files on my hard drive to open by default using 1-2-3. I didn't think that necessarily meant that IE would default to using 1-2-3.

I've actually opened a download in a separate window. Unless I've mis-read things, IE has used Excel to open the file. I'm even more confused now!

Hilary,

Please can you save the version "with out" the Quote marks and send it to me via email. (karl@moneyam.com).

Thanks,

Karl.

OK Karl. As a csv file?

edit: Sent as csv, wk4 and xls (standard workbook & 97-2000)

hilary, you could try changing CSV files to be opened by default in Excel, and see whether it changes IE's behaviour. I thought the controls were separate though, the latter just being in the registry.

Ok ok ok ... after a lot more trawling the net I think I may have found it ...

Can you try to download one again and see if it prompts to save instead of opening straight into the browser?

Karl.

Bingo, Karl, it works! Thanks.

Wooo !!

Yep, it now asks me too, well done.

Karl,

Thanks again for your help.

I've started to import some of the recent ohlcv data retrospectively into my spreadsheet. I haven't cross-referenced the values to other data suppliers yet and am assuming that it is correct as this issue, I believe, was addressed previously.

Out of interest, why on 17th September are there duplicate rows for the UB sectors 13,53,83,85 and 87 which show different values? The UB sectors occupy rows 2931-2969.

I don't know what others feel, but imo it would also be useful to include a column titled "Index" which would display whether each particular epic was within the FTSE 100 or FTSE 250 or FTSE Small Cap or was an index or sector. This would be useful when sorting the data and is offered within Sharescope downloads.

Hilary: Your last para about the Index column. What a great idea. I'll go halfs with you to buy Karl a pint gallon of beer if he does that.

Hil/BT,

I will pass your comments onto Karl,

Ian

I've got more than just legs, BT.

:o)

Hilary, BrianTrayda,

Adding the Index Column is now on the list. No promises as to when it'll actioned.

Karl.

Karl, the beer's going flat while you wait...

No rush, Karl. Tomorrow will be fine.

:o)

Karl,

The download came through this morning without titles. Don't know if it's just me.

Guys,

Karl is on holiday until next Thursday now, but I will make sure he takes a look at any issues when he returns,

Ian