Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I find Canadian Mutual Fund Codes?

324 views
Skip to first unread message

Sylvia and Paul Strauss

unread,
Jan 22, 2002, 6:33:12 AM1/22/02
to
This is a Canadian post. I've been downloading mutual fund quotes into
Quicken for at least 4 years. However, last year I bought a new mutual fund
"AGF RSP International Value Fund" with fund code AGC*RIV. I don't know how
to find the Quicken Code (3 characters and 3 numbers) for this fund.

I think this info used to be posted somewhere (quicken.ca ?), but I just
can't locate it.

Can anyone help?


Dave Brown

unread,
Jan 22, 2002, 8:01:45 AM1/22/02
to
It's AGC*RIV

Click on the fund entry in Quicken portfolio, edit it and click on lookup.
When you go the lookup site, click on FUND in the sub headings across just
above the entry window (it always goes to securities when you use lookup).
On the left hand side, there is another litttle entry window to type in the
fund name. I just used AGF and then when I got a list of all the AGF funds,
scrolled down until I found yours. I clicked on it for more detail and was
finally able to find the above reference.

I agree, not always easy.

Dave
"Sylvia and Paul Strauss" <s.p.s...@rogers.com> wrote in message
news:Y5c38.2554$Okf...@news2.bloor.is...

Sylvia and Paul Strauss

unread,
Jan 22, 2002, 7:30:39 AM1/22/02
to
Thanks for the information, but that's exactly what I've been trying to do -
and it doesn't work.

All my "old" funds in quicken are referenced by a code consisting of 3
letters and 3 numbers (not 3 chars + "*" + 3 chars). Something like
"AGF311". They all update correctly. My only problematic fund (ie. it
doesn't update with new values) is this AGF one.

Just now, in my search for more information, I found the following link
http://www.naq.com/CAN.txt

This file may just contain what I'm looking for. I'm leaning toward AGF434,
AGF414 or AGF863.

*** Dave, am I missing something? Are you actually getting mutual funds
with codes like AGC*RIV to update?

Thanks


Dave Brown <davb...@sympatico.ca> wrote in message
news:Xvc38.3820$Ii5.1...@news20.bellglobal.com...

Sylvia and Paul Strauss

unread,
Jan 22, 2002, 7:50:51 AM1/22/02
to
I put in AGF434 and it worked like a charm! I sure hope www.naq.com
will continue to keep this Canadian page current. I found it purely by
chance (by searching for one of my old quicken codes "AIC111" using
google.com).


Sylvia and Paul Strauss <s.p.s...@rogers.com> wrote in message

news:PXc38.2693$Okf....@news2.bloor.is...

Jean St-Germain

unread,
Jan 22, 2002, 9:07:33 AM1/22/02
to
In order to be able to update my Canadian Mutual fund using Quicken I must
enter the code using "F" ie F:AGF676, F:SMF205, etc. maybe it will work for
you. I do not remember who told me about this but it work for me.

"Sylvia and Paul Strauss" <s.p.s...@rogers.com> wrote in message

news:Led38.2746$Okf....@news2.bloor.is...

Sylvia and Paul Strauss

unread,
Jan 22, 2002, 12:44:57 PM1/22/02
to
Yes, you're right. In fact what I entered below (but didn't specify
explicitly) was F:AGF434. Thanks.
Jean St-Germain <stger...@webruler.com> wrote in message
news:Toe38.1540$On3.29158@localhost...

Dave Brown

unread,
Jan 22, 2002, 9:50:46 PM1/22/02
to
I've got Q2002, my new/old database still shows AGF304 too and works. BUT
AGC*RIV was what I got following the 'lookup' process.. for your fund.

If you get broker statements, depending on your broker, you should also see
the code referenced here. My broker's statement shows AGF304 for my fund.

Beats me why they're different. Interestingly, I have some of the same
securities with different brokers. Their PRICE on the monthly statements
sometimes differ a few cents from my download price so I have a problem
balancing the accounts. The symbols though are the same i.e. AGF304. I
assume there are different sources so thus the difference in price. I don't
think there should be though.


"Sylvia and Paul Strauss" <s.p.s...@rogers.com> wrote in message

news:PXc38.2693$Okf....@news2.bloor.is...

Fred Smith

unread,
Jan 22, 2002, 9:24:51 PM1/22/02
to
To summarize all of the above posts:

AGF304 is the symbol the Canadian server needs, ie, it's the symbol if
you've installed the Canadian version of Quicken. AGC*RIV is the symbol the
US server uses, ie, it's the proper symbol if you've install the US version.

That's why you find different symbols depending on where you look them up.

As was discovered, the actual online symbol needs to be F:AGF304. Newer
versions of Quicken (starting in Q2K, I believe) automatically insert the
'F:' once you've identified the security as a mutual fund. You see the
symbol Quicken is using in the (greyed out) Online Symbol box.

For versions prior to Q2K, you need to enter the 'F:' yourself.

The price on some broker's month end statements will differ from the
downloaded price because many brokers (National Bank, Raymond James, Merrill
Lynch, etc.) use the second last day of the month as their reported price.
I'm told this will be fixed this month, and statements should now properly
reflect the right mutual fund value. About time.

Regards,
Fred.

"Dave Brown" <davb...@sympatico.ca> wrote in message

news:1Fo38.9634$JM6.1...@news20.bellglobal.com...

Paul Vézina

unread,
Jan 23, 2002, 12:02:27 AM1/23/02
to
You can also find the Canadian symbols at
http://www.moneysense.ca/eng/investing/funds/find_fund/index.jsp

As to whether which one of the 3 codes you should use, it depends on the
load type for each fund. The first one is a 'Deferred based on Market
value' load type while the last 2 are 'Front End'

Hope this helps!

"Sylvia and Paul Strauss" <s.p.s...@rogers.com> a écrit dans le message
news: PXc38.2693$Okf....@news2.bloor.is...

Sylvia and Paul Strauss

unread,
Jan 23, 2002, 8:24:36 PM1/23/02
to
Thank you Paul!!! This is the link that I was unable to find!!!! It
absolutely helps!!!
Regards,
Paul


Paul Vézina <paul...@NohotmailSpam.dom> wrote in message
news:Dtr38.4443$Okf....@news2.bloor.is...

0 new messages