Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Fidelity BrokerageLink Transactio Download

Questions about updating prices or transactions in Fund Manager

Postby Mark » Thu Mar 16, 2023 2:04 pm

Okay, interesting. How are you determining the server location used by each product?

Also, in FM you can see the request sent in the "ofxpost.txt" log file located in the same folder as the response log (ofxretr.txt).
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby sgurd4oilop » Thu Mar 16, 2023 5:31 pm

Similar to FM, my banking program provides a log of OFX information as it is transmitted and received. I have pasted below the outputs from those respective logs with confidential info redacted.

From FundManager

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20230316195434.890[-4:EDT]<LANGUAGE>ENG<FI><ORG>fidelity.com<FID>7776</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1><ACCTINFOTRNRS>

<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>1111111</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO>

<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>222222222</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO>

<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>333333333</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO>



From Banking Program

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20230316201036.256[-4:EDT]<LANGUAGE>ENG<FI><ORG>fidelity.com<FID>7776</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1><ACCTINFOTRNRS>

<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>111111111</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO>

<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>222222222</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO>

<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>333333333</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO>

<ACCTINFO><DESC>Brokerage Account<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>444444444</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO>


As you can see the first para in each situation is the "request" and the <FI><ORG> fidelity.com and <FID> 7776 are the same in both programs. From the profile setups on OFXHOME.com I can also find references that both requests move to <FI url> https://ofx.fidelity.com/ftgw/OFX/clients/download if I selected one of the provided accounts to download transactions. The point is, the response back from the same OFX server are two different responses - one with three accounts, one with four accounts. The fourth account is what will NOT download in FM from an earlier setup (and if I delete the account number in NetBenefits server where it is currently setup, that account is not even offered as an option from either Fidelity server). In my banking program, ACCTINFO 4444444 will download transactions from <FID> 7776. But that server also will not offer that account in FM.

I am perplexed.
sgurd4oilop
 
Posts: 27
Joined: Fri Apr 13, 2018 9:19 am

Postby Mark » Thu Mar 16, 2023 5:40 pm

Hi sgurd4oilop,

Interesting... That log file is from "ofxretr.txt", which is the response from the OFX server. What if you look at "ofxpost.txt", and compare the request to what your other program sends as a request?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby sgurd4oilop » Thu Mar 16, 2023 5:59 pm

This is the output of ofxpost.txt after I selected one of the accounts to use as downloading and asking for transactions between 3/1/23 and 3/16/23. I believe I have redacted all confidential information from the posted log. I will have to look into where I can find that similar information in my banking program. Is there some specific element below that I should be looking for?

OFXHEADER:100

DATA:OFXSGML

VERSION:102

SECURITY:NONE

ENCODING:USASCII

CHARSET:1252

COMPRESSION:NONE

OLDFILEUID:NONE

NEWFILEUID:NONE



<OFX>

<SIGNONMSGSRQV1>

<SONRQ>

<DTCLIENT>20230317005035.447

<USERID>[myusername]

<USERPASS>[myuserpass]

<GENUSERKEY>N

<LANGUAGE>ENG

OFXHEADER:100

DATA:OFXSGML

VERSION:102

SECURITY:NONE

ENCODING:USASCII

CHARSET:1252

COMPRESSION:NONE

OLDFILEUID:NONE

NEWFILEUID:NONE



<OFX>

<SIGNONMSGSRQV1>

<SONRQ>

<DTCLIENT>20230317005035.447

<USERID>[myusername]

<USERPASS>[myuserpass]

<GENUSERKEY>N

<LANGUAGE>ENG

<FI>
<ORG>fidelity.com
<FID>7776
</FI>
<APPID>QWIN

<APPVER>2700

</SONRQ>

</SIGNONMSGSRQV1>

<INVSTMTMSGSRQV1>

<INVSTMTTRNRQ>

<TRNUID>15672-FM7-20230317005035.447-447

<INVSTMTRQ>

<INVACCTFROM>

<BROKERID>fidelity.com

<ACCTID>[myacctid]

</INVACCTFROM>

<INCTRAN>

<DTSTART>20230301

<INCLUDE>Y

</INCTRAN>

<INCOO>N

<INCPOS>

<INCLUDE>Y

</INCPOS>

<INCBAL>Y

</INVSTMTRQ>

</INVSTMTTRNRQ>

</INVSTMTMSGSRQV1>

</OFX>
sgurd4oilop
 
Posts: 27
Joined: Fri Apr 13, 2018 9:19 am

Postby Mark » Thu Mar 16, 2023 6:20 pm

Hi sgurd4oilop,

I should have said this before, but that is what the request looks like if FM knows the account number already. Please try it with a blank account number, and the request will look different. You should see a <ACCTINFOTRNRQ> section in the request when FM is asking for the list of available account numbers for your login.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby sgurd4oilop » Thu Mar 16, 2023 6:40 pm

I have to actually select one of the three accounts for anything of note to show up in the ofxpost.txt file. I'm more than willing to post what it shows, but it doesn't show much before I select the account, unless I am doing something wrong.
sgurd4oilop
 
Posts: 27
Joined: Fri Apr 13, 2018 9:19 am

Postby Mark » Thu Mar 16, 2023 8:00 pm

Hi sgurd4oilop,

You can use "File / New Portfolio Wizard..." and leave the Account number blank. Choose to retrieve Transactions and Positions. After you get prompted with the list of accounts, you can just cancel, and not finish the wizard. The ofxpost.txt and ofxretr.txt should both be filled in.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby sgurd4oilop » Thu Mar 16, 2023 9:06 pm

This is ofxretr.txt and ofxpost.net for blank account number using Fidelity NetBenefit OFX server and Fidelity Investment OFX server. It would take a bit more time to get the info from my banking program, although doable I think. They do not separate post and retr however. But it'll have to wait until tomorrow. I've seen enough <> to last a while!

================outputs from using a blank acct number for download========
ofxpost.txt Fid NetBenefits

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20230317034634.391
<USERID>[myuserid]
<USERPASS>[myuserpass]
<LANGUAGE>ENG
<FI>
<ORG>nbofx.fidelity.com
<FID>8288
</FI>
<APPID>QWIN
<APPVER>2700
</SONRQ>
</SIGNONMSGSRQV1>
<SIGNUPMSGSRQV1>
<ACCTINFOTRNRQ>
<TRNUID>17385-FM7-20230317034634.391-391
<ACCTINFORQ>
<DTACCTUP>19700101000000
</ACCTINFORQ>
</ACCTINFOTRNRQ>
</SIGNUPMSGSRQV1>
</OFX>

==========================================
ofxretr.txt Fid NetBenefits

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX><SIGNONMSGSRSV1> <SONRS> <STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20230316234634.772[-4:EDT]<LANGUAGE>ENG<FI><ORG>nbofx.fidelity.com<FID>8288</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1> <ACCTINFOTRNRS><TRNUID>17385-FM7-20230317034634.391-391 <STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><ACCTINFORS><DTACCTUP>20230316234635.223[-4:EDT]<ACCTINFO><DESC>[myacct] &amp; PSP<INVACCTINFO><INVACCTFROM><BROKERID>nbofx.fidelity.com<ACCTID>[myacctid]</INVACCTFROM><USPRODUCTTYPE>[myacct]<CHECKING>N<SVCSTATUS>ACTIVE<INVACCTTYPE>INDIVIDUAL<OPTIONLEVEL>Not Applicable</INVACCTINFO></ACCTINFO></ACCTINFORS></ACCTINFOTRNRS></SIGNUPMSGSRSV1></OFX>

=================================================================
ofxpost.txt Fid Investments

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20230317035031.237
<USERID>[myuserid]
<USERPASS>[myuserpass]
<LANGUAGE>ENG
<FI>
<ORG>fidelity.com
<FID>7776
</FI>
<APPID>QWIN
<APPVER>2700
</SONRQ>
</SIGNONMSGSRQV1>
<SIGNUPMSGSRQV1>
<ACCTINFOTRNRQ>
<TRNUID>18159-FM7-20230317035031.237-237
<ACCTINFORQ>
<DTACCTUP>19700101000000
</ACCTINFORQ>
</ACCTINFOTRNRQ>
</SIGNUPMSGSRQV1>
</OFX>

=======================================================
ofxretr.txt Fid Investments

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20230316235031.645[-4:EDT]<LANGUAGE>ENG<FI><ORG>fidelity.com<FID>7776</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1><ACCTINFOTRNRS><TRNUID>18159-FM7-20230317035031.237-237<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><ACCTINFORS><DTACCTUP>20230316033006.000[-4:EDT]<ACCTINFO><DESC>[FMAcctID]<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>[myacctid]</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>[myacct]<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>[myacctid]</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO><ACCTINFO><DESC>[myacctdesc]<INVACCTINFO><INVACCTFROM><BROKERID>fidelity.com<ACCTID>[myacctid]</INVACCTFROM><USPRODUCTTYPE>NORMAL<CHECKING>Y<SVCSTATUS>ACTIVE<OPTIONLEVEL>None</INVACCTINFO></ACCTINFO></ACCTINFORS></ACCTINFOTRNRS></SIGNUPMSGSRSV1></OFX>
sgurd4oilop
 
Posts: 27
Joined: Fri Apr 13, 2018 9:19 am

Postby sgurd4oilop » Thu Mar 16, 2023 9:08 pm

and if I haven't said so ---- a BIG THANKS to you for all the help and insight you are providing.
sgurd4oilop
 
Posts: 27
Joined: Fri Apr 13, 2018 9:19 am

Postby Mark » Sat Mar 18, 2023 7:34 am

Hi sgurd4oilop,

Thanks for the help. It will be interesting to see the difference between FM's "ofxpost.txt" to Fidelity Investments, versus that of your banking program, since they are receiving different responses.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby sgurd4oilop » Sat Mar 18, 2023 8:44 am

It appears my banking program uses a newer OFX connection protocol. When I look at the OFX log (send and retrieve) this is the start:

connecting to: https://ofx.fidelity.com/ftgw/OFX/clients/download with method: POST
Connecting to ofx.fidelity.com
acceptable TLS protocols: [TLSv1.3, TLSv1.2]
Supported cipher suites:
TLS_AES_256_GCM_SHA384

There are at least another 20 or so TLS "cipher suites" entries.

We can close this thread, as I will use the more secure TLS connection and import/export manually.

Thanks for your help.
sgurd4oilop
 
Posts: 27
Joined: Fri Apr 13, 2018 9:19 am

Postby ASU » Mon Mar 20, 2023 10:08 am

I'm also having this issue with Fidelity. I'd rather not spend hours manually entering transactions to send out quarterly reports in a couple weeks, so any help will be appreciated.
ASU
 
Posts: 20
Joined: Tue Oct 23, 2012 7:25 pm

Postby Mark » Mon Mar 20, 2023 10:29 am

Hi ASU,

Are your accounts also BrokerageLink accounts?

Were they working with Fidelity NetBenefits before, and not now?

If you retrieve from each "Fidelity Investments" and "Fidelity NetBenefits" with an empty account number, do you see your BrokerageLink account number as an option on either of these?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby sgurd4oilop » Mon Mar 20, 2023 3:14 pm

I follow the Q Community on this issue (now 17 pages). This is one of the few Moderator replies to the outrage there:

Hi All, There seems to have been a change that Fidelity made and we are currently working with Fidelity to find the root cause of this error that you are experiencing. We are very sorry that this has been ongoing but we are working on a resolution. Please stay tuned for updates in our alerts. Thank you for your continued patience.

I will let this thread know if I see any resolution such as -- "now it just works" or when it comes to a satisfactory outcome on the Q Community forum.
sgurd4oilop
 
Posts: 27
Joined: Fri Apr 13, 2018 9:19 am

Postby Mark » Mon Mar 20, 2023 4:05 pm

Hi sgurd4oilop,

Thanks for the update. Do you have a link to that Q Community?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

PreviousNext

Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 12 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.
cron