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 Hi John, Could you post a sample line from the file after you've converted it, and I can help with the required import settings.
Thanks, Mark -- Mark Beiley
Fund Manager for Windows 3.1x/95/98/NT
Replies:
|