1. hleofxquotes-team Avatar hleofxquotes-team
  2. open
  3. hleofxquotes

Wiki

Clone wiki

hleofxquotes / mapper_csv

View History

How to use mapper.csv

Why

  • (Common) - You need to map a symbol to type Mutual Fund
  • (Common) - You need to map a "quote source" symbol ABC to msmoney symbol DEF
  • (Advanced) - You need to set a symbol currency. For example, GBX
  • (Advanced) - You need to set a "msmoney" symbol currency. For example: GBP

How

Create file mapper.csv in the current directory (where you run the tool)

Example

Symbol,Type
VOO,M

That said to map Symbol VOO to type Mutual Fund.

Columns

  • Symbol: symbol from quote source (for example: AAPL)
  • MSMoneySymbol: (optional) if the symbol in 'msmoney' different than QuotesSourceSymbol
  • Type: (optional)
    • STOCK or S: default
    • MFUND or M: Mutual Fund
    • OPTIONS or O: Options
    • BOND or B: Bond
  • Currency: default USD
  • MSMoneyCurrency: (optional)

Mutual Fund Type

When a security type is set to Mutual Fund, we will generate the following text block. See MFINFO and POSMF

  <SECLISTMSGSRSV1>
    <SECLIST>
      <MFINFO>
        <!--Ticker from quote source is: FSDIX-->
        <!--DTASOF local time is Fri Apr 28 16:36:34 PDT 2023-->
        <!--Security is treated as Mutual Fund-->
...
      <INVSTMTRS>
...
        <INVPOSLIST>
          <POSMF>
            <!--DTPRICEASOF local time is Fri Apr 28 16:36:34 PDT 2023-->
            <INVPOS>
              <!--Ticker from quote source is: FSDIX-->

Stock Type

When a security type is set to Stock, we will generate the following text block. See STOCKINFO and POSSTOCK

  <SECLISTMSGSRSV1>
    <SECLIST>
      <STOCKINFO>
        <!--Ticker from quote source is: AAPL-->
        <!--DTASOF local time is Fri Apr 21 13:00:04 PDT 2023-->
        <!--Security is treated as Stock-->
        <SECINFO>
          <SECID>
            <UNIQUEID>AAPL</UNIQUEID>
            <UNIQUEIDTYPE>TICKER</UNIQUEIDTYPE>
          </SECID>
...
      <INVSTMTRS>
...
        <INVPOSLIST>
          <POSSTOCK>
            <!--DTPRICEASOF local time is Fri Apr 28 16:36:34 PDT 2023-->
            <INVPOS>
              <!--Ticker from quote source is: FSDIX-->

Updated