Panasonic ADR Termination - ticker change from PCRFY to PCRHY?

Options

Panasonic's stock ticker changed from PCRFY to PCRHY in early April 2024 (having something to do with changing from a sponsored ADR to an unsponsored ADR). It shows up on the brokerage statement as negative PCRFY shares and positive PCRHY shares.

Quicken asked some sort of question about whether the new ticker applied to the shares held under the old ticker that prompted some processing. Afterwards I'm left only with price history since the ticker changed and no price history of the old ticker. I'm missing 5 years of price history resulting in historical pricing at $0. What's the easiest way to resolve this?

Quicken Classic, Version R56.9, Windows 11

Best Answer

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Answer ✓
    Options

    Yahoo Finance and others will produce a csv file that can be opened in Excel and similar. That file typically includes columns for Date, Open, Hi, Low, Close, and Volume, and maybe an adjusted close. and includes a header row.

    For Quicken at its simpler import level, you want Ticker, Date, and Close. Having a header row is acceptable (Ticker, Date, Price) but not required. Date should be in a MM/DD/YYYY format.

    So you open the broader csv file in Excel, Add a column for Ticker and fill each line with the proper symbol as used in Quicken, keep the date and close column, and delete the others. Save that file as a csv file to a known file location.

    Switch to Quicken. File / File Import / Import security prices … — Browse to the saved file location, and click OK. If all is good, you get an message like "Imported XXX security prices".

    There is a hierarchy on price updates. From https://www.quicken.com/support/how-update-security-prices :

    1. Manual price entry
    2. Current Price (Quote)
    3. Historical Price (Quote)
    4. Price downloaded with broker data through One Step Update or Update Now
    5. Import Price (CSV)
    6. Transaction Price entered when manually entering a transaction in the brokerage account list.

    Each entry method overrides the price(s) received by the method just below it. This means that the price displayed after entering a Buy transaction (for example) would be replaced by the price imported from a CSV downloaded from an investing site (such as Yahoo! Finance), which would be replaced by the price transmitted by the broker when performing One Step Update, and so forth.

    While these imported by csv prices are low on the list subject to override by regular or historical downloads, in your case especially, if you are importing prices for PCRHY before April 2, 2024, there is no information available via those download sources and your imported prices should not get overwritten.

    For reference, there is also a way to import prices with hi / lo / vol data. See this FAQ for reference —

Answers

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Options
    1. What does your security list (Ctrl-Y) show? One or two Panasonic securities? What ticker(s)?
    2. When you access the security details and look at the prices history data, what do you see?
    3. What transactions are in your transaction list for this account? Possibly Remove Shares transactions. Possibly Add Shares transactions. Possibly something else?
    4. What do you want? One Panasonic security representing both versions? Two separate securities representing the rigorously correct holdings before and after this event? Something else?
    5. In what fashion is "historical pricing at $0"? Are you looking at net worth or account balance reports? Portfolio views? Some other holding data?

  • kdierking
    kdierking Member ✭✭
    Options

    • 1. What does your security list (Ctrl-Y) show? One or two Panasonic securities? What ticker(s)?

    1 Panasonic security with ticker PCRHY.

    2. When you access the security details and look at the prices history data, what do you see?

    Price history is from 4/2/24 to date.

    3. What transactions are in your transaction list for this account? Possibly Remove Shares transactions. Possibly Add Shares transactions. Possibly something else?

    There are no add/remove transactions.

    There are regular bought, dividend and misc expense (ADR fee, foreign tax paid) transactions.

    4. What do you want? One Panasonic security representing both versions? Two separate securities representing the rigorously correct holdings before and after this event? Something else?

    I would be fine with either scenario of having 1 or 2 Panasonic securities as long as I get historical pricing covering both periods before and after the change. And also keeping the historical cost basis to track gain/loss.

    5. In what fashion is "historical pricing at $0"? Are you looking at net worth or account balance reports? Portfolio views? Some other holding data?

    All reports of net worth, account balances, portfolio value, holdings, investment income for periods prior to the change reflect the value of the stock at $0.

    If there is not a simple fix, I assume that I could manually enter historical month end price history if it would not get overridden when updating price quotes.

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Options

    @kdierking My apologies for letting this drop.

    Followup to #1: Did you also make sure Hidden securities were shown when you checked for 1 vs 2 Panasonics? I'll proceed on the basis that there really is only one Panasonic (the newer PCRHY) in your Quicken file and you are OK with that. If you do happen to spot a second Panasonic (PCRFY) that will change my thoughts.

    If I create (as of 5/16/24) a new security PCRHY and then download historical prices for that security, I get prices for 30 days back to 4/15/24 and then a few more for 4/12 and 4/5/24. That seems to be as far back as Quicken's data supplier reaches for that specific security (ticker). It does not find anything for the PCRFY version. That seems consistent with your info regarding prices only back to 4/2/24. Data snip below.

    A Ctrl-Z keystroke from within the brokerage account transaction list will 'recalculate' the transactions and that should include inserting historical prices into the price history records for applicable securities and transactions (Buys, Sell, Reinvests). Have a good backup on hand just in case something unexpected might happen to some other security.)

    Yahoo Finance also does not show anything for PCRFY and shows PCRHY Daily from 4/2/24. Yahoo Finance does show historical prices for PCRFF from October 15, 2010. Excerpt below. Those prices can be downloaded as a csv file, opened up in Excel (or similar), manipulated there to be in the right columns and formats, saved as a csv file, and then imported. I have no idea what the relationship between PCRFF, PCRFY, and PCRHY might be. Quicken will also download prices for PCRFF, but not daily for more than the last 30 days.

    If you are interested in that form of a PCRFF price import , post back and I can elaborate.

    My only other way to rebuild the prior to 4/2/24 prices would be to restore a Quicken backup from before this change (3/31/24 or earlier?), and get the PCRFY prices from that file into your current file. Of similar difficulty to the Yahoo - csv file process but possibly more accurate and proper. Again, if you'd like to explore that option, I can elaborate.

  • kdierking
    kdierking Member ✭✭
    Options

    Please elaborate on the price import steps. I'm assuming that this would populate price history on the new PCRHY ticker. Would the manually imported price history survive a Get Historical Prices update?

  • q_lurker
    q_lurker SuperUser ✭✭✭✭✭
    Answer ✓
    Options

    Yahoo Finance and others will produce a csv file that can be opened in Excel and similar. That file typically includes columns for Date, Open, Hi, Low, Close, and Volume, and maybe an adjusted close. and includes a header row.

    For Quicken at its simpler import level, you want Ticker, Date, and Close. Having a header row is acceptable (Ticker, Date, Price) but not required. Date should be in a MM/DD/YYYY format.

    So you open the broader csv file in Excel, Add a column for Ticker and fill each line with the proper symbol as used in Quicken, keep the date and close column, and delete the others. Save that file as a csv file to a known file location.

    Switch to Quicken. File / File Import / Import security prices … — Browse to the saved file location, and click OK. If all is good, you get an message like "Imported XXX security prices".

    There is a hierarchy on price updates. From https://www.quicken.com/support/how-update-security-prices :

    1. Manual price entry
    2. Current Price (Quote)
    3. Historical Price (Quote)
    4. Price downloaded with broker data through One Step Update or Update Now
    5. Import Price (CSV)
    6. Transaction Price entered when manually entering a transaction in the brokerage account list.

    Each entry method overrides the price(s) received by the method just below it. This means that the price displayed after entering a Buy transaction (for example) would be replaced by the price imported from a CSV downloaded from an investing site (such as Yahoo! Finance), which would be replaced by the price transmitted by the broker when performing One Step Update, and so forth.

    While these imported by csv prices are low on the list subject to override by regular or historical downloads, in your case especially, if you are importing prices for PCRHY before April 2, 2024, there is no information available via those download sources and your imported prices should not get overwritten.

    For reference, there is also a way to import prices with hi / lo / vol data. See this FAQ for reference —