Fund Manager
Contact Us

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:

: :

: : 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.

Mark Beiley

Fund Manager for Windows 3.1x/95/98/NT

Replies: | Search | Site Map | About Us | Privacy Policy