Re: Historical Price Data
[ Q2 00 - Q2 01 Archive ]
[ Current Message Board ]
[ Archives ]
[ Search ]
Posted by John Rainey on January 04, 2001 at 01:39:08:
In Reply to: Re: Historical Price Data posted by Mark on December 30, 2000 at 18:53:32:
: : Hi Mark,
: : Is it possible to import a spreadsheet list of price data to create a price graph for a single share? I'm not familiar with any of the sites you give examples for in the Help guide for importing. A good site for historical data in the UK is Market-Eye which keeps 5 year records for all listed UK securities, kept in a "csv" spreadsheet form.
: : This would save a lot of hassle having to add in new dates going back some years - I'm a bit of a chartist!
: : Also, is it possible to edit out the "non-loaded and loaded mutual fund" investment type as we don't use that description in the UK, in fact I don't think they exist. Its a drag having them as the default.
: : Regards, John
: Hi John,
: Yes, you can import from a .csv formatted file using the generic import
: command. A .csv file is really a text file. We have an example of how to
: import from Market-Eye on our Tips & Tricks page:
: No, there is no way to remove the investment types you don't use. Thanks
: for the feedback on this.
: Mark Beiley
: Fund Manager for Windows 3.1x/95/98/NT
Hi Mark again,
I've successfully downloaded the Marketeye data but as it is in pence (the standard in the UK)and FM works in whole £'s or $'s, it creates a graph with the Y axis 100 times what it should be. I've divided the Marketeye data by 100 but now the transfer doesn't work. Any ideas?