Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 01-31-2008, 01:55 AM
Wally
Guest
 
Posts: n/a
Default RE: Calculations

Actually, I believe you can get Money to calculate the change for any given
day by using the performance reports. Provided that you have downloaded the
closing price for a given stock for the day and previous day in question, you
can generate a report with a date range of just one day (e.g. January 30 to
January 30). Provided you have downloaded the closing price for January 29,
the report will show you % Rate of Return and the actual dollar return for
January 30. It will not, however, give you the dollar and cent change in the
share price. You could create a watch account with a single share for each
stock to get the change in share price for any given day.

"ygold6" wrote:

- quote -

> Simple question.
> I am using the trial version of MS Money. I've been using Quicken for 10
> years so I understand financial products. My question is does this product
> calculate the difference between yesterdays stock or mutual fund prices
> versus todays prices?
> It appears that it does but if I go back to a day other than todays date and
> try to see what the daily change is, there is no data other than the current
> dates data. Plus over this past week-end, I kept seeing Fridays change on
> Saturday and then on Sunday but only on Stocks and not Mutual Funds. If you
> wish to contact me direct, please e-mail me at ygold6[at]zoominternet.net so
> that I may be able to actually talk to a live person who understands this
> product.
> Thank you
> Bill

  #2  
Old 01-30-2008, 12:35 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Calculations

In microsoft.public.money, ygold6 wrote:

- quote -

> Do you mean to tell me that this product does not maintain daily gains and
> losses for historical purposes?.


I will tell you Money maintains daily prices for historical
purposes. It does not have a function to do the subtraction, but
only downloads the difference. The difference for "today" is that it
takes into account going ex-dividend in computing the difference.

Example:
FSP closed 28 Jan 2008 at $14.60.
$0.31 dividend was ex dividend 29 Jan.
Closed at $14.00. Change on 29 Jan is $0.29 rather than the 0.60
that subtraction would give.

But, as you have found, the portfolio does not show change amounts
when you select a past AsOf date. So it could still have been
designed look for dividends and compute a number for the past. It
doesn't.

- quote -

> Also is there a difference between this
> product and MS Money 2007 an what do you mean with "Configure" in the total
> return.


Money Plus and Money 2007 have the same Total Return columns to
select from.

By configure in total returns, I mean click
ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns

Select each of the seven TotalReturn items, and click Add. Also
select TotalAnnualizedReturn. These will give a better view
of how each of your investments have been performing. You can
reorder them by selecting one in the DisplayedColumns and choosing
MoveUp or MoveDown. You may want to select CostBasis. That column
is very meaningful for non-deferred accounts, but you should not
care about that column for a 401K.

When done, you can do SaveAs. Money will ask for a name for that
view. Then you will be able to select that view with SelectView in
the upper-left of the portfolio. Alternatively, click Save, and
the view that was in effect when you clicked CustomizeCurrentView
will be modified.

You can also reorder and resize columns by dragging the column
headings while viewing a portfolio.

  #1  
Old 01-29-2008, 11:22 PM
ygold6
Guest
 
Posts: n/a
Default Re: Calculations

Cal,
Do you mean to tell me that this product does not maintain daily gains and
losses for historical purposes?. Also is there a difference between this
product and MS Money 2007 an what do you mean with "Configure" in the total
return.
Thank you. Bill

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, ygold6 wrote:
> > Simple question.
> > > I am using the trial version of MS Money. I've been using Quicken for 10

> > years so I understand financial products. My question is does this product
> > calculate the difference between yesterdays stock or mutual fund prices
> > versus todays prices?

> No. It downloads them.
> > It appears that it does but if I go back to a day other than todays date and
> > try to see what the daily change is, there is no data other than the current
> > dates data. Plus over this past week-end, I kept seeing Fridays change on
> > Saturday and then on Sunday but only on Stocks and not Mutual Funds.

> I suggest you configure in the total return for the past week
> column. That is shown as a percent, and it will be the closest
> available when you go back to a historical date. Total return
> includes price change and dividends.

 
Old 01-28-2008, 09:47 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Calculations

In microsoft.public.money, ygold6 wrote:

- quote -

> Simple question.
> I am using the trial version of MS Money. I've been using Quicken for 10
> years so I understand financial products. My question is does this product
> calculate the difference between yesterdays stock or mutual fund prices
> versus todays prices?


No. It downloads them.

- quote -

> It appears that it does but if I go back to a day other than todays date and
> try to see what the daily change is, there is no data other than the current
> dates data. Plus over this past week-end, I kept seeing Fridays change on
> Saturday and then on Sunday but only on Stocks and not Mutual Funds.


I suggest you configure in the total return for the past week
column. That is shown as a percent, and it will be the closest
available when you go back to a historical date. Total return
includes price change and dividends.
  #-1  
Old 01-28-2008, 09:21 PM
ygold6
Guest
 
Posts: n/a
Default Calculations

Simple question.

I am using the trial version of MS Money. I've been using Quicken for 10
years so I understand financial products. My question is does this product
calculate the difference between yesterdays stock or mutual fund prices
versus todays prices?
It appears that it does but if I go back to a day other than todays date and
try to see what the daily change is, there is no data other than the current
dates data. Plus over this past week-end, I kept seeing Fridays change on
Saturday and then on Sunday but only on Stocks and not Mutual Funds. If you
wish to contact me direct, please e-mail me at ygold6[at]zoominternet.net so
that I may be able to actually talk to a live person who understands this
product.
Thank you
Bill
 

Tags
calculations
Similar Threads
Thread Forum Replies Last Post
Budget Calculations
Jason Reeves: I setup an Advanced Budget for the first time, but I'm not sure how Money 2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,...
Microsoft Money 8 09-28-2006 01:30 PM
401(k) Manager Calculations
Farnk: I've been using the 401(k) Manager to update my portfolio with my quarterly statement (since Money 2002 Deluxe). A real annoyance, still around in...
Microsoft Money 24 01-23-2006 05:00 AM
Mortgage Calculations
Money User: Can anyone tell/show me how Money calculates the mortgage principal and interest amounts? I've been pulling (what's left) my hair out the last...
Microsoft Money 6 02-06-2005 02:42 PM
Mortgage calculations
Brenda \(au\): Recently I created a mortgage account in MS-Money (ver: standard, 2003, International apparently) as per bank statements. However none of the...
Microsoft Money 7 08-11-2004 05:02 PM
erroneous roi calculations
cmgilldh: What causes this? I have a mutual fund for which the 3 month and ytd calc is obviously wrong. During this period I transferred the shares from one...
Microsoft Money 1 03-01-2004 06:48 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 12:29 AM.