Navigator User Forums
  BrokerLink
  Viewing OFX files?

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Viewing OFX files?
FN_User
Member
posted 09-18-2008 10:31 AM     Click Here to See the Profile for FN_User     Edit/Delete Message
How can I view the data that I am downloading from my broker? I know it's an OFX file and BrokerLink displays everything on the BrokerLink Transactions grid, but I'd like to see exactly what data the broker is sending.

IP: Logged

David
Administrator
posted 09-18-2008 10:42 AM     Click Here to See the Profile for David     Edit/Delete Message
Here’s how to view the OFX file yourself. This can help you understand what data the broker is sending to BrokerLink. There are a lot of steps below but it’s really pretty quick and easy.

To view the BrokerLink OFX file that you downloaded from the broker:

  1. Open the folder with the OFX downloads. This is normally in the BrokerLink folder in your Navigator program folder, or wherever you store your BrokerLink downloads.
  2. Double click on the OFX file. It should open in Notepad. If it doesn’t, see below.
  3. Look for the transaction in question. It is hard read since it isn’t nicely formatted. See below to format it. An easy way to find the transaction is select Edit | Find and search for the date, price, or just “SELLTOCLOSE”
To format the OFX file for easier viewing:
  1. Go to http://fi.intuit.com/ofximplementation/dcsteps/index.cfm?view=dcdevelop/.
  2. Select Develop tab.
  3. Select OFX Formatter in the Helper Applications section.
  4. Save the file OFXFormatter.zip to your desktop.
  5. Double click on the OFXFormatter.zip file to open it.
  6. Drag or extract the unzipped files to a new folder, perhaps “OFXFormatter.” Leave that folder open for the next steps.
  7. Open the folder with the OFX downloads.
  8. Drag an OFX file and “drop” it on the OFXFormatter.exe file. A new file will be created in the OFX download folder. The new file will have the same name as the original OFX file but with a .tab suffix.
  9. Double click on the .tab file. It should open in Notepad. If it doesn’t, see below.
  10. View the OFX data in the nicely formatted display.
To use Notepad to view files
  1. Double click on the .ofx or .tab file. A message appears “Windows cannot open this file.”
  2. Select Select the program from a list.
  3. Select OK.
  4. Select Notepad.
  5. Select Always use the selected program to open this kind of file.
  6. Select OK. Notepad open and displays the text in the file.

- David
FNI Technical Support
Case #38-10805

[This message has been edited by David (edited 09-18-2008).]

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e