Home → Investments →

Securities Should Allow Specifying the Exchange

• Edit

peter

09 Dec, 2017 03:14 PM

I am using the latest Moneydance preview version and latest Quotes and Exchanges Rates plugin as of the time of writing this message.
Moneydance 2017.6 / Exhanges Rates plugin version v1009.

When I edit a security, there is no field to specify the exchange.

For example, I want to add the security ticker symbol GIB.A for the Toronto Stock Exchange which is Canadian currency.

This is not the same as the GIB symbol for the NASDAQ exchange in USD currency.

When using the Quotes and Exchange Rates extension to update securities, there is an advanced option to specify the exchange as well. However even that feature does not work correctly. For example if a define a security as follows:

Ticker: GIB.A

And then in the Quotes and Exchange Rates extension change the Exchange to Toronto Stock Exchange, the ticker symbol changes from
GIB.A to GIB - this is just broken. See video of the problem: http://take.ms/oehRH

I'd like an option to choose from a current list of exchanges in a dedicated field when editing a security in the main Moneydance program, or since this list may change over time compared to Moneydance releases, provide a field to hard code exchange code value.

My ultimate goal would be to have the Quotes and Exchange Rates extension read from this new field and use that information when specifying the exchange code needed by the remote resource ( ie. Google Finance ) when downloading historical security prices.

For a list of exchange identification codes and aliases, see this standard: https://www.iso20022.org/10383/iso-10383-market-identifier-codes.

From my research there is no international standard to include the exchange code as part of the ticker symbol - so trying to overload the ticker symbol field to allow for also specifying the exchange is a bad idea to consider solving this problem.

1. 1 Posted by derekkent23 on 10 Dec, 2017 11:15 AM

   

   I am not support staff, just a user.

   I live in the UK and don’t have any Canadian stock, but looked up GIB on Google and found it quoted as GIB-A on the Toronto stock exchange. Entered it as GIB-A in the Q & ER set for Alpha Vantage and Toronto Stock Exchange a got a value returned of 68.59. Is this correct for the security you were looking for?

   Hope this helped

   • Edit

2. 2 Posted by peter on 02 Jan, 2018 06:00 PM

   

   Hi - using the latest preview release, i can confirm that entering the stock symbol as GIB-A and the stock exchange as Toronto Stock Exchange, and the currency as CAD that I was able to properly retrieve the stock quote. Thanks for that suggestion.

   I still feel like the exchange should be something integrated directly into Moneydance security editing screens and not only tied to the extension.

   Also whereever I look, I find the symbol displayed as GIB.A , not GIB-A .
   It should be made more obvious what a valid stock symbol is. I have no idea where you determined that GIB-A was the correct format.

   • Edit

3. 3 Posted by derekkent23 on 03 Jan, 2018 09:09 AM

   

   I am not support staff, just a user.

   It is very confusing knowing what symbol to use. I have given up on the Quote and Exchange Rate extension. I now use a Third-Party stand-alone program to obtain quotes and exchange rates and import the results into Moneydance. Being a UK investor, I have found that Alpha Vantage provide very poor support for UK/Irish/Luxenberg etc, domiciled funds. The program provides two sources. In one your symbol is GIB-A.TO the other GIB.A:TOR. Both return the same price. A least the program is easier to use and you don’t import the data into Moneydance until you have had a change to validate the results. If you are interested take a look at this thread and if you try it let us know how it works for you. See http://help.infinitekind.com/discussions/investments/3036-third-par...

   Hope this helps

   • Edit

4. System closed this discussion on 04 Apr, 2018 09:10 AM.