Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Re: Volume scaling factors

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

Posted by Richard Trilling on March 24, 2003 at 23:04:12:

In Reply to: Re: Volume scaling factors posted by Mark on March 18, 2003 at 08:40:08:

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:



FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy