Re: Volume scaling factors

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

In Reply to: Re: Volume scaling factors posted by Mark on March 26, 2003 at 23:40:11:

Mark,

Many thanks, that works just the way I want them to.

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