Tracking CDR Investments

Options
JoelC
JoelC Member ✭✭✭✭

I recently invested in a number of CDRs (i.e., USD stocks that are hedged and traded in CAD examples of which include APPL, HD [Home Depot], META, MSFT, V [Visa], etc.).

I want to track the daily performance of these holdings in the same way that I track the daily performance of my other securities. The problem is that I cannot figure out the symbol to use download the stock prices. The symbol(s) for the exchange that they trade on (i.e., CBOE Canada) do not download any historical prices.

For example as illustrated below, there are three CBOE symbols for the AAPLE CDR (i.e., APPL.DG, APPL.DY and AAPL.ZY) but none download any price history. The correct symbol (per Yahoo Finance and others) is APPL.NE which does not appear as an option.

Would appreciate an explanation about how to download the CDRs historical prices so my portfolio can be updated on a daily basis.

Thank you.

Comments

  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭
    Options

    Well those clearly should work and in fact they do work when you use Quicken's Investing Center site:

    https://www.quicken.com/investing/stock-quotes-investment-research/appl

    but I couldn't get them to work in a Quicken test file.

    Maybe try Official Quicken Support to see if they can come up with a better answer?

  • JoelC
    JoelC Member ✭✭✭✭
    Options

    @Tom Young appreciate the effort and good to know that it is not just me that could not get them to work. I can / will try Official Quicken Support but am not very optimisic.

    Thank you.

  • denbe52
    denbe52 Member ✭✭
    Options

    I wrote a relatively simple Python script (using yfinance) that automatically downloads the prices from Yahoo (e.g. AAPL.NE, AMZN.NE, etc) several times a day and at the end of day. The script creates a CSV file of the prices that I load into Quicken using ("File", "File Import", "Import Security Prices from CSV file") The CSV file looks like this:

    AMZN.NE,22.65,07/05/2024
    AMZN.NE,22.54,08/05/2024

    You can download as much historical data as you need.

  • JoelC
    JoelC Member ✭✭✭✭
    Options

    @denbe52 appreciate teh update and great idea; would you mind sharing the Pythin script? Thank you.

  • denbe52
    denbe52 Member ✭✭
    Options
  • JoelC
    JoelC Member ✭✭✭✭
    Options

    @denbe52, much thanks, I will try it for both the CDRs as well as the few other securities that Quicken does not download.

    Huge thank you!

  • denbe52
    denbe52 Member ✭✭
    Options

    @JoelC - you need to install yfinance using the nospam option

    pip install yfinance[nospam]

    That will automatically install the requests and pyrate limiters

  • JoelC
    JoelC Member ✭✭✭✭
    Options

    @denbe52 appreciate the heds up. I will try to find to work on this over the weekend as I need to tale crash cours eon Python and go for there. I am looking forward to it, just hope the weather sucks.

  • JosefW
    JosefW Member ✭✭
    Options

    @JoelC @denbe52

    Getting quotes from the NEO exchange (for these CDRs and many other ETFs) has been a major oversight on Quicken Canada's part for years. I am amazed at denbe52's ingenuity and resourcefulness, but Quicken should have fixed this years ago. Updating exchange quotes should be a foundational part of their program.

    I just got an email from CEO Eric Dunn touting all the wonderful advances Quicken is making, but not a word about Canadians. - Link to message from Quicken CEO Eric Dunn

    Canadians are such a small part of their user base that suggestions like these drop to the bottom of any user request list. The latest official note on this is that, with some 53 requests, it was upgraded to "Under Consideration" back in the fall of 2023 - "Under Consideration ·Last Updated October 2023 - Submitted for review on 8/28/23, CBT-167/CTP-7672" (No word since, but requests are still being posted.)

    Here is a discussion underway on this -

    In the meantime, I just check the quotes from other sources, enter them manually and hope that someday they get around to adding it.

  • JoelC
    JoelC Member ✭✭✭✭
    Options

    @JosefW , I goe so frustrated that I ended up selling the securities, converting CAD to USD and buying the actual securities. I dug into the CDRs n greater details and was put off by the cost of the hedge.

    @denbe52, I thank you for your solution noting I was able to get it working (with the help of a friend who is more Python capable than me).

  • Arctic Hare
    Arctic Hare SuperUser ✭✭✭✭
    Options

    I've been expressing concerns regarding Quicken's newsletters for years. I've even complained to the Office of the President. They never contain any Canadian content. They very reinforce the message that Quicken views its Canadian users as 2nd or 3rd class.

  • JoelC
    JoelC Member ✭✭✭✭
    Options

    @Arctic Hare please, do not get me started.

    I have four issues that Quicken determined were "must fix" issues because the math / reporting was wrong. I was working with their engineering team very closely then all of a sudden the person I was working with was no longer available, I was passed to the Office of the President and I now get e-mails that are identical (i.e., I think they are auto generated) and read that my issue is important, engineering is working on it but there is no end date in sight.

    I am very frustrated with this particularly given that I discovered an anomaly that renders the P/L incorrect when an investment account is coded a a business account. What is the point of financial software when the P/L is wrong?

    End of rant!

  • Arctic Hare
    Arctic Hare SuperUser ✭✭✭✭
    edited May 17
    Options

    I am receiving similar emails from the OotP. Mine are in relation to the inability to download transactions from BMO Bank of Montreal. The issue started at the beginning of February and there is no end in sight as to when it will be resolved. I will acknowledge that the emails I receive are not auto-generated, but fixing the inability to download transactions should not take months. I did have one major issue that took literally years to get resolved - with regular follow ups.

  • JoelC
    JoelC Member ✭✭✭✭
    Options

    @Arctic Hare , I am very sorry to read that. I hope both of our issues get resolved in the near term as they are critical functional and reporting issues. I feel and share your pain.

  • Brent H
    Brent H Member ✭✭
    Options

    Agree with the comments here. I received that same email from Quicken touting all of the exchanges that they now support, but am frustrated that I cant get the AMZN, MSFT and other symbols for CDR's from the NEO exchange. Congratulations to Denbe52 for the python code and import method to enable. Now if we can get quicken to see how simple it is, and import this functionality it would be great. But alas, the canadians here are such a small market, we get ignored.