nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fidelity - how can I download transactions for a specific date range - they only have CSV format ?

saberman

I need to check stock transactions for a specific date. Is it possible to put a date range for downloading transactions?

Find more posts tagged with

Accepted answers

All comments

UKR

Yes, but only if the brokerage, on their website, allows you set a Date Range for downloading transactions into a Quicken compatible (QFX) file which you can import into Quicken.

Ps56k2

saberman said: Is it possible to put a date range for downloading transactions?

Totally up to your specific brokerage - and if they allow manual downloading, and for what date range involved....
What brokerage ?

Quicken has no control over what your brokerage provides -

saberman

Quicken connects to the brokerage house and requests transactions for a date range. The question is how to control the date range.

Ps56k2

saberman said: Quicken connects to the brokerage house and requests transactions for a date range.
The question is how to control the date range.

What brokerage ? -

and as mentioned - it is via the brokerage online website - totally a manual downloading process from their website.
Log into the brokerage website, view your accounts, and look for a MANUAL download ....
which may or may not exist - which is why we have asked for which brokerage it is -

IF the manual download is avail from this un-named brokerage -
then you might be able to specify the date range -
again totally depends on the brokerage website.... and what dates you are looking to download.

IF this un-named brokerage allows a manual download,
and IF the date range can be specified on the website,
and IF the date range is what you want -
then a Quicken formatted file might be part of their downloading capability....
which will create a downloaded Quicken QFX file that is then Imported into your desktop Quicken software....

saberman

>which is why we have asked for which brokerage it is
It is Fidelity. They have an option to download to Excel but not to Quicken. Quicken determines what transactions to download.

Ps56k2

saberman said: They have an option to download to Excel but not to Quicken.
Quicken determines what transactions to download.

NOPE - it's Fidelity that has chosen to only manually download in the Excel CSV format -
and NOT support the Quicken QFX manual download called - Web Connect -

07776 07776 07776 Fidelity Investments http://www.Fidelity.com (800) 544-7931
http://personal.fidelity.com/misc/partners/quicken/disclaimer.shtml ACTIVE
INVESTMENT,ACCOUNTINFO&DIRECT

Here is Vanguard - and their support for the manual website downloading -
called - WEB CONNECT - which is missing on Fidelity.

15103 15103 15103 Vanguard https://investor.vanguard.com/home/ 1-888-285-4563
https://investor.vanguard.com/corporate-portal/ ACTIVE
INVESTMENT,ACCOUNTINFO,401K&DIRECT
INVESTMENT,401K&WEB-CONNECT

saberman

The link: http://personal.fidelity.com/misc/partners/quicken/disclaimer.shtml
throws a page not found.

BTW, the option transactions come in fine if they are downloaded before the options expire.

Ps56k2

saberman said:

The link: http://personal.fidelity.com/misc/partners/quicken/disclaimer.shtml
throws a page not found.

That's an internal Quicken URL - for accessing the Fidelity accounts -
it's part of what's called the Quicken Financial Institution Directory List - FIDIR List -
which is what is displayed when you perform the Quicken Add Account -

Ps56k2

WOW - asked and answered your same Fidelity downloading question - 2 years ago -

https://community.quicken.com/discussion/7882364/how-do-i-download-old-transactions

saberman

It is not my day -- link produces:
Permission Problem
You don't have permission to do that.

Ps56k2

Guess it was a 2 year old topic where you had the exact same Fidelity downloading Q&A and it was then archived …

saberman

OK, what is the answer?

Chris_QPW

saberman said:

OK, what is the answer?

You can't do it, you need the financial institution to provide a QFX file for the above operation, and Fidelity doesn't do that.

If you are hell bent on trying you can try a conversion from CSV to QIF or QFX with my program ImportQIF, but noted this isn't easy. Because of the lack of standards in CSV format/data content you have to map the columns to the right QIF/Quicken Fields and at conversion time tell ImportQIF what each security action name means.
You can get ImportQIF from here: https://www.quicknperlwiz.com/

Ps56k2

From October 2020 - your same question -

https://community.quicken.com/discussion/7882364/how-do-i-download-old-transactions

saberman Member ✭✭

October 2020

>Which FI are you dealing with?
Fidelity Investments.

I finally created the account as a new account. Ran the download.
It said it was downloading transactions for the last 81 days. However it was missing a lot.
I gave up and manually created the transactions I was missing from the FI's activity report.
Then I deleted the new account.