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; } } }

New Investment account setup with avg cost basis

SVA

Hello,

I tried to setup a new quicken file and connect with brokerage account with 400+ securities which is 10+ year old. Quicken download historical transaction and create several place holders which make it very time consuming to go through 100s of those place holders. I would like to see a way where quick can download the current date or point in time(within the year…) and get the number of share along with avg. cost basis to setup the accounts in quicken w/o adding any place holders and I would like quicken to track any future transactions from the brokerage accounts. I am not sure if there any other option to avoid the place holders for brokerage accounts that very old and which might large number of holdings.

Find more posts tagged with

Reviewed

Status: Reviewed

Comments

NotACPA

400+ securities in a, presumably personal, investment account???

Q isn't the right product for you. You need software that's a dedicated investment tracking tool.

And, how far back a download into a new Q account can download is determined by the FI, not Q. But 30-90 days is customary … so your 10 years is WAY out of range, which is why you got all of those placeholders.

q_lurker

As I see it, the more fundamental problem is that the brokerage downloads typically do not include cost at all - either by lot or by total cost basis of the holding. Indeed, I've never known any to provide that information. Quicken cannot dig in to the brokerage information to extract the info (financial institutions are naturally not willing to let outside software access client data). I'm sorry, but it comes down to the user to fill in that separate data.

I suppose it might be possible to create a csv file with the necessary info and import that into Quicken (as Add Shares transactions), but even that process is relatively new and may have significant quirks to work past.