1. Home
  2. Quicken Personal Finance
  3. Report Showing Basis?

Report Showing Basis?

Greets,

I need to run a report, for my broker, which shows the ***PER SHARE*** cost basis of my portfolio. The "Portfolio Value and Cost Basis" report shows a cumulative basis for the entire position (cost-averaged for reinvestements), so is not useful.

Can someone please let me know if Quicken 2007 has a way to do this?

(In an effort to keep the discussion on track, for those people who would want to respond with 'why does your broker need this', the answer is that my mother passed away and I did the calculations for the step up in basis, which straddled a weekend as she passed away on a Sunday; meaning that the cost basis was the average per share price on the Friday before and the Monday after). I know this is off point, but I am trying desperately to get the question answered, rather than field follow-up questions.

Thank you so very very much!

Reply to
Ira
Loading thread data ...

I use Q2005Deluxe, but the following works for me. Go to the Investing Center and set up a report for Quotes. I can customize to add High and Low for the day which is what you want. Then Print the report (miner is Print Portfolio) and select print to a tab delimited disk file. You can then open in a speadsheet pregram and add a column to average the high and low. Just do that for Fri and Mon and then average the averages.

Reply to
Charlie K

I use Q2005Deluxe, but the following works for me. Go to the Investing Center and set up a report for Quotes. I can customize to add High and Low for rhe day which is what you want. Then Print the report (miner is Print Portfolio) and select print to a tab delimited disk file. You can then open in a speadsheet file and add a column to average the high and low. Just do that for Fri and Mon and then average the averages.

Reply to
Charlie K

If I understand your question correctly, I think you want to see the cost basis for each lot within each position. It looks like you should be able to get this by going to the Porfolio View and clicking on the "+" next to each position. This creates a drop down under each position that shows each lot along with cost basis for that individual lot. Once you have each of these positions expanded, then print from the "file" menu and it will include all of the individual lots.

I hope this helps and am sorry for your loss.

Jeff

Reply to
Jeff M

Jeff,

This DOES work. Thank you very much. Thank you also for the kind words. Its good to see people out there who help!

Thank you!

On Mon, 05 Nov 2007 17:25:00 -0800, Jeff M wrotf:

Reply to
Ira

Charlie,

Thank you for your response. Your response was telling me how to calculate the basis, rather than print it - but that has now been solved, and I thank you for your help!

On 5 Nov 2007 11:20:53 -0800, Charlie K wrotf:

Reply to
Ira

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.