Getting this error message trying to import a CSV. Portfolio file has these two different securities with similar tickers:
GOOG (USD currency, listed on the Nasdaq exchange)
GOOG.NE (CAD currency, listed on the Neo exchange)
They are different symbols, different stock value, different quote feed, etc.
However trying to import a CSV with the ticker GOOG it fails with the error “Ticker GOOG exists multiple times in the list of securities” but it only exists once in the list of securities. Apparently “GOOG” is also matching “GOOG.NE”. I put GOOG’s ISIN in the security data but that didn’t help.
Can the code be modified to only match ticker if the entire string matches?
Hi everyone, I have the same issues with a multiple securities - it is always the same security, but purchased on the different stock exchange and/or in different currency.
Thanks for help!
The reason why the “matching” works the way it works is this:
The ticker symbol is a complicated beast. It combines the ticker with the suffix for the stock exchange. For example, the bank might right a purchase on IQQE, but you have configured the Frankfurt stock exchange of the historic prices IQQE.F. Then you still want the bookings imported for the same instrument. Therefore when matching instruments, the exchange part is stripped from the ticker.
Can you share the two symbols that you are having a problem with? Are those really two different instruments?
I haven’t done an import for sometime but have got it into my head that the last one I performed featured the appropriate ISINs, but no ticker symbols.
Maybe that approach could be a good solution to this issue - GOOG’s ISIN on Nasdaq is US02079K1079, which is very different to CA02080K1049, the ISIN for GOOG.NE as listed on the Neo exchange
As described in my original post, the two instruments GOOG and GOOG.NE are completely different. Different exchanges, different currencies, different price, etc. Putting in the ISINs doesn’t seem to solve the import error - still says GOOG is duplicated when trying to import GOOG.NE.
Yes, preferably the ISIN is used during import to choose the correct instrument since the ISIN will be unique even if the root of the symbol is the same.
Two other instruments that exhibit the same problem are META and META.NE.
The former (ISIN US30303M1027) is in USD and trades on the Nasdaq exchange while the latter (ISIN CA59101A1012) is in CAD and trades on the NEO Exchange (CBOE Canada).
