Sharesmagazine
 Home   Log In   Register   Our Services   My Account   Contact   Help 
 Stockwatch   Level 2   Portfolio   Charts   Share Price   Awards   Market Scan   Videos   Broker Notes   Director Deals   Traders' Room 
 Funds   Trades   Terminal   Alerts   Heatmaps   News   Indices   Forward Diary   Forex Prices   Shares Magazine   Investors' Room 
 CFDs   Shares   SIPPs   ISAs   Forex   ETFs   Comparison Tables   Spread Betting 
You are NOT currently logged in
 
Register now or login to post to this thread.

(BETA) Market Close Data Download (BETA)     

Karl(MoneyAM) - 19 Aug 2004 17:27

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(MoneyAM) - 14 Sep 2004 16:19 - 51 of 218

Hilary,

And so the mystery deepens ...

K

Kayak - 14 Sep 2004 16:22 - 52 of 218

hilary, try first opening the CSV file Karl sent you (specifying comma-delimited), come out of that, and then download it again straight into 1-2-3 via Karl's screen. It may be that the default CSV file format it uses is the last one used.

hilary - 14 Sep 2004 16:31 - 53 of 218

Still can't get it to open, K., but don't worry about it now. Hopefully Karl now understands the problem and I'll be able to get it to work next week once he's done his fix. Thanks for your help.

hilary - 22 Sep 2004 11:21 - 54 of 218

Karl,

Have you an update yet on the speech marks issue?

BrianTrayda - 22 Sep 2004 12:00 - 55 of 218

Or the earlier download time (7pm) ?

Karl(MoneyAM) - 22 Sep 2004 12:58 - 56 of 218

Hilary, BrianTrada,

Thank you for the reminder. The changes are on my to-do list but as the product is only in BetaTest they havn't been actioned as yet due to a other commitments. I will post back as soon as they are live and tested.

Karl.

Karl(MoneyAM) - 22 Sep 2004 13:41 - 57 of 218

Hilary,

I have just made the changes regarding the quotation marks.

There is now an option to switch them off. Although I had to leave them for the company name as some of them had commas in them. Also it changes the format of the data. The data is now "raw" but Excel deals with it ok.

Hope that helps.

K

hilary - 22 Sep 2004 15:18 - 58 of 218

Thanks Karl,

I'll look at it a bit later and let you know how I get on.

hilary - 22 Sep 2004 17:15 - 59 of 218

Karl,

I've saved a CSV file but the separators are only working from the 4th column (Open Price). The first 3 columns are not separating and end up in column A. The titles from Row 1 are also not separating and all end up in Cell A1. The Volume column still closes with a speech mark.

Back to the drawing board.

:o(

Kayak - 22 Sep 2004 21:43 - 60 of 218

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.

hilary - 23 Sep 2004 10:25 - 61 of 218

K.,

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

Kayak - 23 Sep 2004 10:27 - 62 of 218

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.

hilary - 23 Sep 2004 10:37 - 63 of 218

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!

Karl(MoneyAM) - 23 Sep 2004 11:00 - 64 of 218

Hilary,

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

Thanks,

Karl.

hilary - 23 Sep 2004 11:02 - 65 of 218

OK Karl. As a csv file?

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

Kayak - 23 Sep 2004 11:18 - 66 of 218

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.

Karl(MoneyAM) - 23 Sep 2004 11:37 - 67 of 218

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.

hilary - 23 Sep 2004 11:43 - 68 of 218

Bingo, Karl, it works! Thanks.

Karl(MoneyAM) - 23 Sep 2004 11:45 - 69 of 218

Wooo !!

Kayak - 23 Sep 2004 12:04 - 70 of 218

Yep, it now asks me too, well done.
Register now or login to post to this thread.