≡	Fund Manager PORTFOLIO MANAGEMENT SOFTWARE

Re: 50 Day Moving Average and Current Price To Excel

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

Posted by Mark on March 21, 2004 at 19:03:27:

In Reply to: 50 Day Moving Average and Current Price To Excel posted by Ron on March 21, 2004 at 16:44:18:

: I want to download 50 Day Moving Average Price and Current Price for about 150 assets in one portfolio daily. Is it possible to do this into EXCEL? I also need to know which version to use for this.

Hi Ron,

You can create a custom report with the 10 week (50 days) moving average
and the ending share price. Then, use "Edit / Copy Text" and go paste this
into a text file. Then, you can open this text file into Excel. When
opening it in excel you'll want to use the "Fixed Width" option to parse the
text file.

Thanks,
Mark
--
Mark Beiley

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

Replies:

| | | |