Home Page link  

Downloading from brokerage

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Downloading from brokerage Caryl 06-20-2006
Posted by Caryl on June 20, 2006, 8:55 am
Please log in for more thread options
 I am not able to download one of my brokerage accounts into Quicken and
have been inserting the activity for this account manually. However, I
just discovered on the account's website that I can download into
either Excel or as a CSV file. Which should I do so that I can then
transfer this information into Quicken, and how do I transfer it into
Quicken once it is downloaded?

I have Q2005 Deluxe and Excel 2002.

Thank you.

Caryl


Posted by John Pollard on June 20, 2006, 9:45 am
Please log in for more thread options
>I am not able to download one of my brokerage accounts into
>Quicken and
> have been inserting the activity for this account manually.
> However, I
> just discovered on the account's website that I can download
> into
> either Excel or as a CSV file. Which should I do so that I can
> then
> transfer this information into Quicken, and how do I transfer
> it into
> Quicken once it is downloaded?
>
> I have Q2005 Deluxe and Excel 2002.

I think you may find the process frustrating, and possibly not
worth the effort; QIF files were never a very satisfactory way
to get investment data into Quicken, and matters have only
gotten worse beginning with Q2005.

To get your data into Excel:

1.) Download from the brokerage (if they truly offer an Excel
file, that should do the trick, but either a true Excel file or
a CSV file can be opened in Excel).
2.) Use the free Excel macro, "xl2qif" (Google for it) to
convert the Excel data to a QIF file
3.) Pre-process, then import, the QIF file using instructions
found here:

http://makeashorterlink.com/?Q11A5191D

I believe you will find that the names of your Quicken
securities must match exactly to the names downloaded from your
fi. You can modify the names in the downloaded data anytime
prior to importing to Quicken, or you can change the names in
Quicken.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Caryl on June 20, 2006, 12:31 pm
Please log in for more thread options

John Pollard wrote:
> I think you may find the process frustrating, and possibly not
> worth the effort; QIF files were never a very satisfactory way
> to get investment data into Quicken, and matters have only
> gotten worse beginning with Q2005.

John,

Thank you for your very clear and easy-to-understand instructions. But
I think what you said above is most important. Since this particular
account does not trade very much, it seems easiest to just continue as
I have been doing, downloading my Fidelity accounts through Quicken and
manually adding any trades or dividend receipts for this Bear Stearns
account.

Caryl


Posted by Hank Arnold on June 21, 2006, 4:52 am
Please log in for more thread options
I download quotes from Yahoo! Finance every week in CSV format. You can
import the prices directly into the portfolio page...

Regards,
Hank Arnold

Caryl wrote:
> I am not able to download one of my brokerage accounts into Quicken and
> have been inserting the activity for this account manually. However, I
> just discovered on the account's website that I can download into
> either Excel or as a CSV file. Which should I do so that I can then
> transfer this information into Quicken, and how do I transfer it into
> Quicken once it is downloaded?
>
> I have Q2005 Deluxe and Excel 2002.
>
> Thank you.
>
> Caryl
>

Posted by Caryl on June 21, 2006, 10:41 am
Please log in for more thread options
Hank Arnold wrote:
> I download quotes from Yahoo! Finance every week in CSV format. You can
> import the prices directly into the portfolio page...

Thank you for your advice. However, the problem is not downloading
quotes, which I can do, but downloading transactions in that account
(buying, selling, and income).

Caryl


Similar ThreadsPosted
Downloads From Brokerage February 24, 2008, 10:29 pm
Combining two brokerage accounts? November 2, 2006, 2:17 pm
Moving stocks to a brokerage December 17, 2007, 3:58 pm
Brokerage Account Consolidation February 14, 2008, 10:59 pm
Online brokerage account glitch July 7, 2006, 12:56 am
Yield On T-Bills in Brokerage Account December 14, 2006, 2:53 am
Brokerage account/Scheduled Transaction January 5, 2007, 8:28 pm
How do I move all transactions from on brokerage acct to another? June 27, 2007, 10:57 pm
Brokerage firm with "best" Quicken integration August 19, 2007, 1:29 pm
recent vanguard brokerage issues and downloads January 4, 2007, 8:52 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap