Importing Transactions from Questrade

MyronD

Hello all,
I have the Quicken Home, Business & Rental Version of Quicken ver.R32.12 Build 27.1.32.12.
I am trying Questrade, my Canadian broker does now not have a direct connect to Quicken. I have to download my transactions to an Excel file. Can Quicken import this Excel file and update my transactions without having to manually input the data?

Thanks

NotACPA

Is Excel the only file format that Questrade can export?  Any others?

And, if you do a Google search, you'll find multiple products that can convert a CSV style file into something that Q can import.

You can start that search here: http://www.quicknperlwiz.com/

Boatnmaniac

Sorry, but Excel files cannot be imported into Quicken.  However, you might want to try using ImportQIF.  ImportQIF is freeware that was developed by one of the more prolific Community members and a long-time user of Quicken.  It can be downloaded from http://www.quicknperlwiz.com/.  The site says that ImportQIF has limited support for converting Excel files to an importable version of QIF which can then be imported into Quicken.  I have not used this program myself but others in this Community have and said it works pretty well.

NotACPA

Is Excel the only file format that Questrade can export?  Any others?

And, if you do a Google search, you'll find multiple products that can convert a CSV style file into something that Q can import.

You can start that search here: http://www.quicknperlwiz.com/

Boatnmaniac

Sorry, but Excel files cannot be imported into Quicken.  However, you might want to try using ImportQIF.  ImportQIF is freeware that was developed by one of the more prolific Community members and a long-time user of Quicken.  It can be downloaded from http://www.quicknperlwiz.com/.  The site says that ImportQIF has limited support for converting Excel files to an importable version of QIF which can then be imported into Quicken.  I have not used this program myself but others in this Community have and said it works pretty well.

Ps56k2

MyronD said:  I have to download my transactions to an Excel file.

What exact file format does this Questrade actually download - CSV or XLS ?

MyronD

Questrade downloads in XLS format.