Report Showing Basis?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Report Showing Basis? Ira 11-05-2007  Re: Report Showing Basis? Charlie K 11-05-2007  Re: Report Showing Basis? Charlie K 11-05-2007  Re: Report Showing Basis? Ira 11-05-2007  Re: Report Showing Basis? Jeff M 11-05-2007  Re: Report Showing Basis? - SOLVED - Thank you Jef... Ira 11-05-2007
Posted by Ira on November 5, 2007, 9:59 am Please log in for more thread options 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! Posted by Charlie K on November 5, 2007, 11:52 am Please log in for more thread options > 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! 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. Posted by Charlie K on November 5, 2007, 2:20 pm Please log in for more thread options > 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! 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. Posted by Ira on November 5, 2007, 8:50 pm Please log in for more thread options 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! >> 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! > >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. Posted by Jeff M on November 5, 2007, 8:25 pm Please log in for more thread options > 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! 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 Similar Threads Posted Report showing running shares July 8, 2007, 11:11 am Can I run a report of one investment in one account showing running totals? July 12, 2008, 3:33 pm Report Wont Ask to Create Reconcile Report March 15, 2008, 7:42 pm Vanguard midcap not showing changes August 25, 2006, 10:35 pm Purchased security not showing August 6, 2007, 12:20 pm Downloaded Transactions not showing September 11, 2007, 7:06 am reconcile not showing all transactions August 13, 2008, 6:57 pm PAYX showing a yield of 0.00 September 26, 2008, 10:51 pm Cannot Create New Report From Existing Report December 30, 2007, 3:53 pm accounts not showing on start page December 6, 2007, 3:03 am