Re: Volume scaling factors

[ Q3 01 - Q1 03 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: Volume scaling factors posted by Richard Trilling on March 24, 2003 at 23:04:12:

Hi Richard,

You should be importing this back into the same investment that you
originally exported it from. You'll just overwrite the existing
close/open/high/low/volume with the exported/modified version of this data.

Thanks,
Mark
--
Mark Beiley

Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP

: Mark,

: That doesn't quite work the way I need it to work. All the volumes are mutiplied by 100 as I wanted.

: However I loose a lot of the other information which is not exported:

: the number of shares,
: splits,
: buy/sells

: None of this information is exported.

: What is exported is: close,date,volume, high,low,open

: Some how it seems that what I have to do is imprt the file back into the orginal file.

:
: Richard

: : Hi Richard,

: : Sure. Please also include what format string you're trying now.

: : Thanks,
: : Mark
: : --
: : Mark Beiley
: :
: : Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
: :

: :
: : : I can't get the ipmport part to work it refuses the string.

: : : Can I send you via email my CSV file and the format string so you can tell me what I'm doing wrong?

: : : Richard

: : :
: : : : : Mark,

: : : :
: : : : : For historic reasons, basically because I used to be on CompuServe, a number of my date files have all the "volume" quantities divided by 100.

: : : :
: : : : : Is there an easy way that I can on selected file (quote) basis multiply all volume entries in these files by 100.

: : : :
: : : : : Thanks,

: : : :
: : : : : Richard

: : : : Hi Richard,

: : : : There is no built in command to do this in Fund Manager, but you could
: : : : pretty easily accomplish this by:

: : : : 1) FM - File/Export/Prices/CSV...
: : : : 2) Excel - Read in the file, and multiply the Volume column by 100
: : : : 3) Excel - Save the file as a .csv file
: : : : 4) FM - File/Import/Prices/Generic...

: : : : Thanks,
: : : : Mark
: : : : --
: : : : Mark Beiley
: : : :
: : : : Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
: : : :

Replies:

• Re: Volume scaling factors Richard Trilling 01:19:41 03/28/03 (0)