Home Page link  

Report Showing Basis?

  
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
Report Showing Basis? 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 ThreadsPosted
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
Cannot Create New Report From Existing Report December 30, 2007, 3:53 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
accounts not showing on start page December 6, 2007, 3:03 am

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