Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 06-04-2008, 08:37 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How can I group investments

In microsoft.public.money, Cal Learner-- MVP wrote:

- quote -

> In microsoft.public.money, brett wrote:
> > > > That looks really neat but the problem I'll experience is it wanting

> > to rearrange my formatting on each import. Is there a way I can have
> > it just update the market value in specific cells?

> http://www.microsoft.com/downloads/i...splayLang%3den
> shows a quote download for Excel 2002/2003. I don't know if that
> same thing works for later versions.


p.s., I just tried it in Excel 2007 and it works fine.
  #4  
Old 06-04-2008, 08:27 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How can I group investments

In microsoft.public.money, brett wrote:

- quote -

> That looks really neat but the problem I'll experience is it wanting
> to rearrange my formatting on each import. Is there a way I can have
> it just update the market value in specific cells?


http://www.microsoft.com/downloads/i...splayLang%3den
shows a quote download for Excel 2002/2003. I don't know if that
same thing works for later versions.

  #3  
Old 06-04-2008, 06:38 PM
brett
Guest
 
Posts: n/a
Default Re: How can I group investments

On Jun 4, 10:33*am, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:
- quote -

> In microsoft.public.money, brett wrote:
> > On Jun 4, 9:05*am, Cal Learner-- MVP <via_newsgr...[at]please.tnx> wrote:
> > > In microsoft.public.money, brett wrote:
> > > > I'm using Money Plus Deluxe (2008). *Is there a way to group
> > > > investments in the portfolio view using your own custom grouping?
> > > > For example, my broker lets me create groups such as Gold, Energy,
> > > > Large Cap, etc. *I then assign any position to those groups. * Money
> > > > seems to force you to use its groups and then auto allocates on what
> > > > it believes the positions are (equities, funds, options, etc). * I'd
> > > > like to have more of a drag/drop and full control over the grouping.
> > > > I'd like each grouping to display a dollar total and percent
> > > > allocation on each of its holdings.
> > > Money does not have that ability.
> > > It would be nice if you could maybe have something like "%a%=gold
> > > %b%=Fred" included in the menu and have Money group by a selected
> > > custom string. Memo is from the Comments field of the investment
> > > details.
> > > You can sort by the Memo column now, but that does not subtotal.

> > I like Money and think it is a good program. * Maybe they'll add this
> > down the road but the recent versions haven't had any break throughs
> > or innovations.
> > I'm using Excel for now and just manually tracking everything.

> Have you tried Ultrasoft Moneylink lately?http://ultrasoft.com/MoneyLink/overview.shtml
> It's free and trustworthy.http://www.microsoft.com/money/Impor...taToExcel.mspx
> I don't see how to get the memo field, but perhaps you could prefix
> the security name with a code and sort by that.- Hide quoted text -
> - Show quoted text -


That looks really neat but the problem I'll experience is it wanting
to rearrange my formatting on each import. Is there a way I can have
it just update the market value in specific cells?

Thanks.
  #2  
Old 06-04-2008, 05:33 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How can I group investments

In microsoft.public.money, brett wrote:

- quote -

> On Jun 4, 9:05*am, Cal Learner-- MVP <via_newsgr...[at]please.tnx> wrote:
> > In microsoft.public.money, brett wrote:
> > > I'm using Money Plus Deluxe (2008). *Is there a way to group
> > > investments in the portfolio view using your own custom grouping?
> > > For example, my broker lets me create groups such as Gold, Energy,
> > > Large Cap, etc. *I then assign any position to those groups. * Money
> > > seems to force you to use its groups and then auto allocates on what
> > > it believes the positions are (equities, funds, options, etc). * I'd
> > > like to have more of a drag/drop and full control over the grouping.
> > > I'd like each grouping to display a dollar total and percent
> > > allocation on each of its holdings.
> > > Money does not have that ability.
> > > It would be nice if you could maybe have something like "%a%=gold

> > %b%=Fred" included in the menu and have Money group by a selected
> > custom string. Memo is from the Comments field of the investment
> > details.
> > > You can sort by the Memo column now, but that does not subtotal.

> I like Money and think it is a good program. Maybe they'll add this
> down the road but the recent versions haven't had any break throughs
> or innovations.
> I'm using Excel for now and just manually tracking everything.


Have you tried Ultrasoft Moneylink lately?
http://ultrasoft.com/MoneyLink/overview.shtml
It's free and trustworthy.
http://www.microsoft.com/money/Impor...taToExcel.mspx


I don't see how to get the memo field, but perhaps you could prefix
the security name with a code and sort by that.

  #1  
Old 06-04-2008, 04:57 PM
brett
Guest
 
Posts: n/a
Default Re: How can I group investments

On Jun 4, 9:05*am, Cal Learner-- MVP <via_newsgr...[at]please.tnx> wrote:
- quote -

> In microsoft.public.money, brett wrote:
> > I'm using Money Plus Deluxe (2008). *Is there a way to group
> > investments in the portfolio view using your own custom grouping?
> > For example, my broker lets me create groups such as Gold, Energy,
> > Large Cap, etc. *I then assign any position to those groups. * Money
> > seems to force you to use its groups and then auto allocates on what
> > it believes the positions are (equities, funds, options, etc). * I'd
> > like to have more of a drag/drop and full control over the grouping.
> > I'd like each grouping to display a dollar total and percent
> > allocation on each of its holdings.

> Money does not have that ability.
> It would be nice if you could maybe have something like "%a%=gold
> %b%=Fred" included in the menu and have Money group by a selected
> custom string. Memo is from the Comments field of the investment
> details.
> You can sort by the Memo column now, but that does not subtotal.


I like Money and think it is a good program. Maybe they'll add this
down the road but the recent versions haven't had any break throughs
or innovations.

I'm using Excel for now and just manually tracking everything.
 
Old 06-04-2008, 04:05 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How can I group investments

In microsoft.public.money, brett wrote:

- quote -

> I'm using Money Plus Deluxe (2008). Is there a way to group
> investments in the portfolio view using your own custom grouping?
> For example, my broker lets me create groups such as Gold, Energy,
> Large Cap, etc. I then assign any position to those groups. Money
> seems to force you to use its groups and then auto allocates on what
> it believes the positions are (equities, funds, options, etc). I'd
> like to have more of a drag/drop and full control over the grouping.
> I'd like each grouping to display a dollar total and percent
> allocation on each of its holdings.


Money does not have that ability.

It would be nice if you could maybe have something like "%a%=gold
%b%=Fred" included in the menu and have Money group by a selected
custom string. Memo is from the Comments field of the investment
details.

You can sort by the Memo column now, but that does not subtotal.



  #-1  
Old 06-04-2008, 03:43 PM
brett
Guest
 
Posts: n/a
Default How can I group investments

I'm using Money Plus Deluxe (2008). Is there a way to group
investments in the portfolio view using your own custom grouping?
For example, my broker lets me create groups such as Gold, Energy,
Large Cap, etc. I then assign any position to those groups. Money
seems to force you to use its groups and then auto allocates on what
it believes the positions are (equities, funds, options, etc). I'd
like to have more of a drag/drop and full control over the grouping.
I'd like each grouping to display a dollar total and percent
allocation on each of its holdings.

Thanks.
 

Tags
group, investments
Similar Threads
Thread Forum Replies Last Post
Add Category Group
Mr. Wizard: Is it possible to add to the "Category Group" list in Money Plus Deluxe? Mike
Microsoft Money 1 11-16-2007 01:50 PM
tax deferred investments now seperated from taxed investments in performance report
Dave Programmer: I'm running Money 2005. In some cases I have the same investment in both a tax deferred and regular account. Until just a couple of days ago, when...
Microsoft Money 5 10-28-2007 04:00 PM
This group has cooled down
someone: Interesting how this group has cooled down. Nothing seems resolved so the cycle just starts over again for 06.
Microsoft Money 2 11-13-2004 03:09 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 04:31 AM.