Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Just 3 transactions from Fidelity

Questions about updating prices or transactions in Fund Manager

Postby Kelvin » Thu Jan 07, 2016 9:18 am

When I download transactions for my Fidelity account, I'm getting just three at a time. I've just downloaded the latest FM, so I'm using Personal version 2016.14.3.100, transaction module 213. If I go back, telling it to skip existing transactions, with the same dates, I get the next set of three transactions. If I tell it not to skip existing transactions, then I continue to get the first three transactions for the period requested.
Kelvin
 
Posts: 15
Joined: Thu Oct 14, 2010 7:28 am

Postby Mark » Thu Jan 07, 2016 9:27 am

Hi Kelvin,

If you do "All Dates", and turn off "Skip Transactions in Fund Manager", do you see all of your transactions? You should. If not, go look in your "xmldump.txt" file, and see if it is showing just the one's displayed, or if it has more. This log file will be located here:

C:\Users\<username>\AppData\Roaming\Fund Manager
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Kelvin » Thu Jan 07, 2016 10:08 am

I chose 1/1/2015 - 1/7/2016 for dates, turned off Skip Transactions. I get just three transactions, for the first three months of 2015 (one per month). xmldump.txt shows just those transactions. Interestingly, it shows DTSTART as 20150101, and DTEND as 20150401 (date portion). There are two transactions in December; if I start on 10/1/2015, DTEND shows up (date & time) as 20151229230000.000, which happens to be just before the second transaction of the month on 12/30/15. (FWIW, I have just one active investment in the account.)

When I choose All Dates, I get all transactions from October to present; xmldump.txt shows DTSTART as 20151009, DTEND as 20160107. I note that in ofxpost.txt, if I choose All Dates, there is no DTSTART; if I choose specific dates, there is a DTSTART but no DTEND. So it looks to me like the server is generating its own dates if none is specified. It's not clear to me why it's choosing a shorter period if there are more than three transactions in a quarter, but does the OFX specification permit you to send a DTEND date?
Kelvin
 
Posts: 15
Joined: Thu Oct 14, 2010 7:28 am

Postby Mark » Thu Jan 07, 2016 6:05 pm

Hi Kelvin,

I'm surprised you can get transactions from before 90 days ago on Fidelity. Usually they only offer the last 90 days worth of transactions. Maybe it is that they will only provide up to 90 days worth of transactions in a single request. If DTSTART is omitted from the request the server is supposed to respond with all available data. DTEND is optional, and can limit the end date range of the requested data. Could it be that depending on what date range you request, you're only getting back at most 90 days worth of history, and you only have 3 transactions in any given 90 day window? If so, you could request data in 90 day chunks to get the full history.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Kelvin » Thu Jan 07, 2016 7:41 pm

I think you're right that it's limiting it to 90 days, and it's just happened that that was three transactions for me. The fact that it cut it off between Dec. 29 & Dec. 30, when Dec. 30 had more transactions, misled me, but as I think about it, 10/1-12/29 is 90 days; 3 months is a bit longer. I just tried starting 10/15/15, and I get the transactions for 10/30, 11/30, 12/23, and 12/30. So it's automatically limiting to 90 days, but it's not being flagged. It would be nice for FM to check the DTEND returned, and if that's earlier than the requested end date, display a warning.
Kelvin
 
Posts: 15
Joined: Thu Oct 14, 2010 7:28 am

Postby Mark » Fri Jan 08, 2016 8:32 am

Hi Kelvin,

Interesting, thanks for sharing your learnings. A warning would probably be a good idea if the DTEND is significantly before the most recent business day.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 11 guests

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