none
How I modify SymbolMap.csv for MSMoneyQuotes as I add Stocks RRS feed

  • General discussion

  • When using MSMoneyQuotes (I will call it MQ for short below), you have the option of using the SymbolMap to look up the symbols faster and with less web traffic. When you first run MQ with the -m switch, MQ creates the  SymbolMap.csv
      https://gaiersoftware.com/Money/DetailsAndHelp

    What this thread is about is how to update that file easily when you later add securities. I understand that even easier would be to rename or delete the existing  SymbolMap.csv so a new one gets created.
    -

    1. Set up your command windows to allow copy and paste.

    -

    2. Run MQ in a command window using the -m and -v switches. Pipe the output to the find command like this example:

      c:\apps\MSMoneyQuotes.exe -m -v |find /V "OK"|find /V "->"

    I use a batch file rather than typing this each time. What that stuff after the | says is to don't send the successfully found symbols to the screen -- just the other stuff.

    -

    3. Keep the output on the command window screen.

    -

    4. Edit the SymbolMap.csv file with your favorite text editor (not word processor). I ahve been using Notepad++, but Notepad or other text editor should work.

    -

    5. On the command window referred to in step 3, select and copy the symbols that were not already in SymbolMap.csv. The screen snip shows 4 symbols selected. Copy.

    -

    6. Paste the copied lines under the existing lines in SymbolMap.csv.

    -

    7. Replace all occurrences of " -> " with ",". Note the spaces at each end of the string
    to be replaced.

    -

    8. Save the modified SymbolMap.csv. You are done.

    -

    I did not fill in most of the step details. Those who might try this will already know how to do some of those things. Ask for detail on any of the steps you want.







    Tuesday, December 24, 2019 7:32 PM
    Moderator