Re: Historical Price Data
[ Q2 00 - Q2 01 Archive ]
[ Current Message Board ]
[ Archives ]
[ Search ]
Posted by Mark on January 04, 2001 at 18:43:32:
In Reply to: Re: Historical Price Data posted by John Rainey on January 04, 2001 at 01:39:08:
: : : 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:
: : http://www.fundmanagersoftware.com/tips.html
: : No, there is no way to remove the investment types you don't use. Thanks
: : for the feedback on this.
: : Thanks,
: : Mark
: : --
: : 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?
: Regards, John
Could you post a sample line from the file after you've converted it, and
I can help with the required import settings.
Fund Manager for Windows 3.1x/95/98/NT