UK Fund Symbols for MS Money Quotes

[Stephen Google]

I use symbolmap.csv to map the ISIN codes for my UK funds to the 6 letter code used by MS Money Quotes. Does anyone have the codes for these UK funds which I can't locate on the MSN Money web site?

GB00B5ZSNC6 M&G Pan European Sustain Paris Aligned I Acc.

GB00B46J9127 M&G Global Dividend Fund Sterling Class R Acc.

Also I still can't get prices for National Grid NG.

[Mike Wylde]

For NG. I use aoc1bh 

[Bill Hackney]

M&G European Sustain Paris Aligned I Acc is ap5aar.  I searched for "European Sustain Paris", because starting the search with "M&G" returns too many options in the Instrument Search on the Gaier website.

Likewise,  M&G Global Dividend Fd Sterling Cls R Acc shares is ap4vz2.  I searched for "Global Dividend R Acc".

Because of the way that long fund names can get abbreviated in different ways by different service providers, I do a Google search using the ISIN, then try the different variants I see, in the Instrument Search.

You should check that the prices that MSMoneyQuotes returns look correct.

[Stephen Google]

Excelllent!  ap5aar &  ap4vz2 are the codes I needed. Now I just need to fix National Grid. I mapped NG. to aoc1bh but the prices don't update using MS Money Quotes.

[Stephen Google]

I just discovered the price search for the first symbol I insert in symbolmap.csv fails. I had NG. set as the first symbol to search. I just inserted another line containing the same information NG. aoc1bh and the search worked. This appears to be a bug.

[Michael Wylde]

That’s odd, the stock in my first line works.

--
You received this message because you are subscribed to a topic in the Google Groups "Microsoft Money" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/microsoft-money/mhZ7qhzcNvU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to microsoft-mon...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/43523b71-64c6-49e3-867c-601e452f0a7bn%40googlegroups.com.

[Cal Learner]

Stephen: as a test, consider opening SymbolMap.csv with a spreadsheet. The items are separated by a comma. That might help make any differences in the two lines stand out. Do not then save that file. Spreadsheet programs can do funny things such as adding quote characters.

Alternatively, copy SymbolMap.csv to temp.csv, and open that copy.

[Stephen Google]

I currently put the ASIN reference e.g. GB00B2PLJN71   in the first spreadsheet column then the Financial Instrument e.g. apj3yc   in the second column which works apart from prices for the first first row not being updated. Should I just put all in the first column e.g. GB00B2PLJN71,apj3yc

[Michael Wylde]

I have 2 columns, for stocks it’s the ticker (NG., AZN, etc) and the instrument (aoc1bh etc) in the 2^nd column. Written in Excel, saved as csv.

For my few unit trusts the first column is codes like 0P00000QWU – I forget what that’s called, is it ISIN? 2^nd column the fin instrument code, in this instance apf8jc.

To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/00b38807-9d49-4f48-8009-3bc7361fcec4n%40googlegroups.com.

[Cal Learner]

I suggest that you do not use a spreadsheet program to work on SymbolMap.csv for real. I was just suggesting the spreadsheet to do read-only inspection.

A CSV file is a text file, and everything before the first comma is the first column. Each comma defines a new column has started.

Spreadsheets, such as Excel, extend this to use various quote characters to do things, the simplest of which is to allow commas within a column/item. These extensions are not universal. So for MSMoneyQuotes, I would only use a simple text editor such as Notepad or Notepad++ to make changes to  SymbolMap.csv.

I use Notepad++ to take captured verbose screen info from running MSMoneyQuotes to produce new lines to SymbolMap.csv

https://en.wikipedia.org/wiki/Comma-separated_values

[Stephen Google]

Maybe the failure to get prices for the first line is because I have always used Excel to create symbol.csv? Anyway the issue was easily fixed by duplicating the first and second rows.

[Cal Learner]

Stephen: I suspect this is related to your issue. I don't find that Dan Gaier said it was OK to edit  SymbolMap.csv with Excel or other spreadsheet.     What you test and describe will potentially be of help to others. I have a few experiments to propose, if you are up for it.

 Open a command window. CD to the folder that contains SymbolMap.csv

Then do these commands, or use your favorite methods to do the same things:

copy  SymbolMap.csv  temp.csv.

notepad temp .csv

This should open a copy of  SymbolMap.csv. What do you see different in the first two lines?

If I do the following command in a command window that is looking at the file that contains SymbolMap.csv

 I get no lines found. If I did that right, it says my SymbolMap.csv file has no lines with single or double quote characters.  Assuming that you have such characters, I would remove them. If you have only a few entries, you could do that with Notepad. If you have many, we can discuss ways to better automate that.

findstr "[\'\"]" SymbolMap.csv

Please let us know what you find.

[Cal Learner]

1. I would encourage anybody using MSMoneyQuotes to run this command from a command window. Either CD to the folder containing  SymbolMap.csv or use a fully qualified pathname for  SymbolMap.csv.  I expect nothing to be found for most, but if there are matches and your    MSMoneyQuotes is working fine, then I would suspect that Dan has made the program more robust by being more permissive about what works.

findstr "[\'\"]" SymbolMap.csv 

Please let us know what you find if you try that.

2. In my previous post, I accidently added a space to filename for

notepad temp.csv

This would only be noticed, I think, if you did a copy and paste.