F2O f2o_beta11C.zip uploaded.

[Cal Learner]

I posted  f2o_beta11C.zip

This is the same folder used for previous versions.  This is a folder rather than a file:
https://drive.google.com/drive/folders/1-4fBbRxaPhNYZK0gNHuZ3n-Bdoncy2aR?usp=sharing

In the folder is f2o_beta11c.zip, which has several files. One file is earlier documentation aimed at the PocketSense user who has files from when Fidelity's OFX server still worked.  F2Obeta.doc is in Word 97 format, and  F2Obeta.txt which is is the text-only version.

Beta11C  updates F2O.py file and adds these:
 
 F2O_New_User_intro.docx #aimed at the person who is starting with no good Fidelity*.ofx files saved
 Autogen_fresh_F2O_DB_OnceOnly.bat #a batch file for that person to run ONCE.

The F2O.py only makes noticable changes for a few people (including me).

Feel free to post comments, bugs, or why did you do something the way you did. The code evolved starting in March 2023.

You should be able to copy the zip contents over your existing F2O files.

[-Kevin N]

Hi Cal,

f20_beta11c seems to work as expected.  

I did not install it from scratch.  Rather I let it overwrite the existing files in my F2O folder.

I don't have any new txns but F2O did not throw any errors - so that's good. :)

Q. Would it be possible in the future for F2O to mimic the behavior of Pocketsense in allowing for a single combined OFX file?

It was prophetic of you to prepare for this day.  Kudos.

Thank you for sharing your work with us all.

-Kevin N.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Since ofx servers are still present at citibank card and pnc bank for me, pocketsense combines those ofx files for me along with the f2o ofx files, and it scrubs the fidelity files for me as well.

[-Kevin N]

Hi Dan,

Are you saying that if I put my 5, F2O OFX files into the Pocketsense 'import' folder and then run Pocketsense for Regions Bank, (which still provides OFX servers) that Pocketsense will combine the Regions Bank OFX files with the F2O OFX files?

-Kevin N.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

yes.  simply add your import path to f20_cfg.py like this:

OVERRIDE_WRITE_FOLDER="C:/Users/Dan/Documents/Microsoft Money/Python Scripts/import/"   # direct where the created ofx files should be saved, instead of default

[-Kevin N]

Hi Dan,

Wow!  That's fantastic!  All these years that I've used PS, I never knew that.  Awesome!

Thanks

-Kevin N.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

from my article:

 By eventually saving the created OFX files into your Python Scripts Import folder, his current intentions are to continue to allow Pocketsense to scrub and process those files.   For example, among other things, Cal’s Pocketsense scrubber (scrub_cL6.py) removes BUYMF and SELLMF transactions for Fidelity’s SPAXX, FDRXX (and perhaps 1 or 2 more now) holdings, so that Money will treat them like the cash sweep holdings that they are, rather than investments.  I also have the scrubber omit the memos.

[-Kevin N]

Hi Dan,

I actually DO have FDRXX and SPAXX as investments, so I do not want to scrub those BUYMF and SELLMF txns.

I just tried the 'import' process and I'll be darned; it does indeed combine everything.  Awesome! :)

I can't wait now for the end of the month when I'll have actual txns from Fidelity to try it out for real.

Thanks again,

-Kevin N.

[Gaurav Kumar]

I have updated my copy to include code which recursively looks for ofx file inside a base folder, and copies all ofx files to import dir.

This helps me in saving ofx files created outside of pocketsence download organized. 

Eg: vanguard and equate+ allows ofx downloads. Rest of them give csv files, which i convert to ofx using icreate.

Regards,
Gaurav

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/657810e6-b4a1-4bbb-bd73-e00ec23f95b3n%40googlegroups.com.

[Cal Learner]

I just did something similar.

My batch file so far:

===================

rem F2Ops.bat
cd %USERPROFILE%\F2O
f2o.py
move fid*.ofx %USERPROFILE%\MN\PS_dev\import\
pause hit key to continue to ps.bat Cntl+C to abort
ps.bat
==============================

ps.bat is an existing batch file. I first did setup.py in PocketSense to delete the Fidelity accounts 

[Cal Learner]

F2O f2o_beta11D.zip uploaded to the same folder used for previous versions. Still in
https://drive.google.com/drive/folders/1-4fBbRxaPhNYZK0gNHuZ3n-Bdoncy2aR?usp=sharing

Also F2O_stuff_notes.txt explains  the latest  PocketSense scrubber (Scrub_CL7.py)

[Cal Learner]

Thanks Tom. Corrected.

On Monday, January 26, 2026 at 12:31:16 PM UTC-6 tom.h...@gmail.com wrote:

Please check the " f2o_beta11D.zip" name.   I'm seeing  f2o_beta1D.zip

Thx

[-Kevin N]

Hi Cal,

What does Scrub_CL7.py do?

Per F2O_stuff_notes.txt...

>3. If using Pocketsense I suggest using the Scrub_CL7.py scrubber in your Pocketsense folder.

Does Scrub_CL7.py go into the main Pocketsense folder or the Pocketsense / import folder?

-Kevin N.

[Cal Learner]

 Scrub_CL7.py goes into the main Pocketsense folder.

[Cal Learner]

What does Scrub_CL7.py do?

TLDR: Not important with F2O. 

Most of what it does is not important with F2O AFAIK.  Some functions were important to me when processing the directly downloaded OFX.  However the OFX generated by F2O already has a lot of those objectives handled.

Inspired by your question, I just did a file comparison of what F2O produces and what is in the XFR folder (after scrub). Very little difference for Fidelity! I expected more difference.  I like Agent Ransack for doing file comparisons.

It does still have important stuff to do for Vanguard (via import folder) and maybe others. 

For Fidelity checks that the dates will be correct regardless of timezone. 

Checks that the dates are not Saturday or Sunday.

Look back at your old transactions, I expect you may find some are a day off.

Removed/ignored some transactions, such as buys and sells of typical core holdings (I like that, but others may not)

Removed Increase/decrease collateral for those who do the security lending program.

Put the OFX pieces on separate lines to be more human readable.

Again, F2O pre-does most of these things, so for Fidelity only it is not important.  For Vanguard via the import folder, I think it is still very important. For Citicard... not sure there is a need. Citicard direct download still works great.

[-Kevin N]

Hi Cal,

Thank you for the explanation.

So, considering that I DO need to include money market tnxs from Fidelity and the other financial institutions mentioned are not relevant to my situation, I should NOT use the scrubber.  Correct?

-Kevin N.

[Cal Learner]

You do not need to use the scrubber. 

I looked to see if F2O.py somehow ignores them. I did not see that, but maybe I missed something. Let us know if your FDRXX info makes it into your FID*.ofx files

[-Kevin N]

Hi Cal,

OK.  I will have FDRXX txns and SPAXX txns at the end of the month.  I'll report back then.

Just for the record, both FDRXX and SPAXX are included in F2O_DB.csv.

-Kevin N.

[Cal Learner]

f2o_beta11E.zip has been uploaded and  f2o_beta11D.zip removed.  2o_beta11C.zip still there for the moment, and will be deleted soon.

1. Fixes F2O.py  bug where foreign tax paid was ignored.

2. Adds initial line with date of version.  This one prints "F2O Fidelity-specific CSV 2 OFX converter  Dated 2026/01/26" or just look at the first line of F2O.py

3. Includes F2O_New_User_intro.doc instead of F2O_New_User_intro.docx, which had been unreadable at least once.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Kevin, the scrubber sentence in my article was a little misleading, and I changed the sentence to:

For example, among other things, Cal’s Pocketsense scrubber (scrub_cL6.py) removes BUYMF and SELLMF transactions for Fidelity’s SPAXX, FDRXX (and perhaps 1 or 2 more now) holdings, so that Money isn’t tracking all the movement in and out of the cash sweep account.

The MMFs are investments, but do you really need to track all of the movement in and out of the cash sweep account?

[-Kevin N]

Hi Dan,

Do I really need to...  'need' may be a little strong but I 'prefer' to do so as in doing so, the balance of the 'Cash Transactions' section of the register is always $0.00.

This creates an easy-to-follow checks and balances wherein if the 'Cash Transactions' balance is 'not' $0.00 then I know something is amok.

That's the way I've always done it, so you know what they say about old dogs. :)

-Kevin N.

[Cal Learner]

Kevin... interesting idea. 

Do you have to select View settlements in money market funds each time you get the History CSV, or is that sticky enough. Reset value is not that.

I did a comparison of the CSV each way. 

[-Kevin N]

HI Cal,

It has been my experience that the 'View settlements in money market funds' toggle is sticky.

-Kevin N.

[-Kevin N]

Hi Cal,

F2O Fidelity-specific CSV 2 OFX converter  Dated 2026/01/28

Happy to report that transactions for both FDRXX and SPAXX imported as expected.

-Kevin N.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Fidelity has always posted pending transactions 3 - 4 days early in the history (marked in Bold) and positions screens for me, but the OFX server never transmitted those until the actual date.  I've observed that the history and positions csv downloads reflect those pending transactions, and the statements reflect sold investments that haven't happened yet, confusing Money.

Not an issue that needs to be fixed; I'll adjust ;)

[zanzibar743]

That's weird. One thing I always liked about the Fidelity OFX downloads was that it updated Money as of the trade date, not the settlement date. Interesting that it's the opposite for you.

I posted  f2o_beta11C.zip

This is the same folder used for previous versions.  This is a folder rather than a "https://drive.google.com/drive/folders/1-4fBbRxaPhNYZK0gNHuZ3n-Bdoncy2aR?usp=sharing" rel="nofollow noreferrer" target="_blank" data-saferedirecturl="https://www.google.com/url?hl=en&q=https://drive.google.com/drive/folders/1-4fBbRxaPhNYZK0gNHuZ3n-Bdoncy2aR?usp%3Dsharing&source=gmail&ust=1769956583281000&usg=AOvVaw2ghu-4ovi4mTyC2uqlpZjQ">https://drive.google.com/drive/folders/1-4fBbRxaPhNYZK0gNHuZ3n-Bdoncy2aR?usp=sharing

In the folder is f2o_beta11c.zip, which has several files. One file is earlier documentation aimed at the PocketSense user who has files from when Fidelity's OFX server still worked.  F2Obeta.doc is in Word 97 format, and  F2Obeta.txt which is is the text-only version.

Beta11C  updates F2O.py file and adds these:
 
 F2O_New_User_intro.docx #aimed at the person who is starting with no good Fidelity*.ofx files saved
 Autogen_fresh_F2O_DB_OnceOnly.bat #a batch file for that person to run ONCE.

The F2O.py only makes noticable changes for a few people (including me).

Feel free to post comments, bugs, or why did you do something the way you did. The code evolved starting in March 2023.

You should be able to copy the zip contents over your existing F2O files.

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/657810e6-b4a1-4bbb-bd73-e00ec23f95b3n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/943afc4c-1202-4c43-ae8b-70aa45717bdfn%40googlegroups.com.

[Cal Learner]

I would like to adjust if it causes an inconvenience.
If things are in flux, I can test and ignore transactions that were dated after yesterday or some such... we can think about it.

Are you thinking the positions lag behind the history entries-- I routinely tell Money to not adjust. To bad there is not a setting to make that Money's default.

Or we may find that there is a time window that is best to not download the CSVs.

The one time I had an anomaly that might be related is that the same transaction I had accepted got duplicated because the FITID changed, and that changed because the history line changed. I recognized the duplicate and voided the second instance. Because I had the CSVs, I could investigate the cause.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Here's an example of 2/2/2026 transactions (and position adjustments) downloaded today (1/31/2026):

Feb-02-2026

Investments ***1779

INTEREST BANK HAPOALIM B M NEW YORK CD 4.45000% 02/02/2026 (Cash)

+$952.42

Feb-02-2026

Investments ***1779

REDEMPTION PAYOUT BANK HAPOALIM B M NEW YORK CD 4.45000% 02/02/2026 (Cash)

+$42,000.00

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Cal, here is the only F2O generated ofx file section I can find, in case it proves helpful.  The position for that CD isn't reported as ZERO qty; it is simply not showing, so Money is asking to change qty to zero.  I select ignore, so that on Monday, the actual redemption can be matched.

<!--ofx1_init--><!-- build div--><INCOME>
<INVTRAN>
<FITID>MQXEWXQNAXM7LHLXF6N420260202
<DTTRADE>20260202120000
<MEMO>06251A6L9 BANK HAPOALIM B M NEW YORK CD 4
</INVTRAN>
 <SECID>
<UNIQUEID>06251A6L9
<UNIQUEIDTYPE>CUSIP
 </SECID>
<INCOMETYPE>INTEREST
<TOTAL>952.42
<SUBACCTSEC>CASH
<SUBACCTFUND>CASH
</INCOME>
<!-- build div--><INCOME>

[Cal Learner]

I think that is OK. I could add an ability to ignore future transactions. Give it some thought.

I expect in the Money register, the future transaction is below a darker top border line.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Cal, you stated " I would like to adjust if it causes an inconvenience.

If things are in flux, I can test and ignore transactions that were dated after yesterday or some such... we can think about it."

If you do address this issue, please don't ignore any current day transactions.  I kind of reconcile on a daily basis, and that won't work if things are a day behind ;) 

Schwab is known for being a few days behind in posting transactions, and it makes manual daily reconciling more difficult.

[Cal Learner]

I was thinking of maybe including todays after maybe 4pm ET. In any case, I would probably make it configurable. I am not sure if it would even be desirable.

[zanzibar743]

My comment related to securities transactions. I think you're is a special situation because it's a CD, not a stock transaction. Interest is calculated the business day before maturity so that it's available on the maturity date. 

To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/066e9954-2abc-4305-972a-9fa719ead7e5n%40googlegroups.com.

[Ameridan (microsoftmoneyoffline.wordpress.com)]

Cal, as I stated before, you don't need to address my issue on my behalf.  I can work around it - in fact if I see the BOLD transactions, I can simply not download the history csv that day.

[Cal Learner]

I will be watching to make sure those future-dated transactions do not get duplicated. If the line/row in the Accounts_History*.csv does not change, there will be no duplication. If that line changes, the FITID changes, and there will be duplication. I am expecting that duplication will not happen, but if it does, that will be the reason to act.