F2O Situation Handling--Advanced Discussion

[Cal Learner]

What happens when a symbol/ticker changes? It does not happen very frequently, but it happens.

Case study:
https://infomemo.theocc.com/infomemos?number=58212
Medical Properties Trust, Inc. (MPW) will change its trading symbol to MPT effective February 2, 2026. As a result, option symbol MPW will also change to MPT effective at the opening of business on February 2, 2026. [CUSIP stays 58463J304 in this case]

The latest Accounts_History*.csv and  Portfolio_Positions*.csv have no reference to the old MPW symbol.

How could this be handled?

Method 1:
1a. When running F2O.py, you get info caused by this being a symbol that is not already in F2O_DB.csv database. It then says "Can now add a new F2O_DB.csv entry. I suggest STOCK".
1b.  You see MPT,"MEDICAL PROPERTIES TRUST INC" in the strings above, You use Money to see what symbol is being used by MEDICAL PROPERTIES. Find it is MPW.
1c. With this knowledge, you use a search engine and discover the situation.
1d. You Cntl+C out of F2O.py.
1e. You inspect F2O_DB.csv   for a line that contains "MEDICAL PROPERTIES". Your database already has a line that says "MPW,58463J304,STOCK,MEDICAL PROPERTIES TRUST INC", perhaps with some optional trailing commas
1f. You modify that line to be, or make a new line that says
"MPT,58463J304,STOCK,MEDICAL PROPERTIES TRUST INC"
1g. In Money, you change the symbol for MEDICAL PROPERTIES TRUST INC to MPT (if you don't Money will think MPW is still the symbol, but things will work)
1h. You restart F2O.py, and it runs to completion. Money reads the OFX file no problem.

Method 2:
start the same as 1a and 1b and maybe 1c.
2c. You accept Money creating a new entry in F2O_DB.csv. F2O creates a new entry with CUSIP zzzzzzKMT, and runs to completion.
2d. Upon processing the FID*.ofx file, Money says there is a new investment. It asks if this is a new security, or if you already have this security. It provides a drop-down list. You select "MEDICAL PROPERTIES TRUST INC".
2e. Money asks if it should change the symbol to KMT, and you say yes. KMT works fine in the future.

I am don't plan to automate this more. Even if I wanted to, there is no csv info about the symbol change. https://digital.fidelity.com/ftgw/digital/portfolio/activity does not even have a record to point out the symbol change. I guess I could add an Exit choice in addition to 'MF', 'STOCK', 'OTHER', 'OPT', 'DEBT' so that the person would not have to know about using Ctrl-C.

Today I would probably call a REIT a stock, but if I had set it up as OTHER, I would need the type to be OTHER also. That would be an advantage to method 1 -- you would know to keep the type consistent.