Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Old 10-06-2011, 06:44 AM   #41
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Quote:
Originally Posted by pb4uski View Post
You might try using Quicken for a small subset of your portfolio to see if it will provide for your needs.

While I'm not sure if it will get you all the information you are looking for, it may get you a huge chunk of it and you can link Quicken to your stockbroker accounts and automatically download transactions. The reporting is quite flexible and you can always import the data into Excel if you want a particular format for a report and the raw data is available but Quicken reports won't do the trick.

Also, since you seem to be a sophisticated user, there may well be specific investment tracking and reporting software out there that would work better for you.

But even if you could link your stockbroker accounts to Quicken to use Quicken to handle the drudgery of tracking transaction (including dividend reinvestments) and then import the data to Excel for reporting it sounds like you would be ahead of the game.

Good luck.
Thanks for the suggestion. Below is a sample of the data for which I am seeking an alternate source (in the event that the Yahoo provided info ceases to be freely available):

Symbol;Close;EPS(ttm); Div/Shr;Ex-Div

-----A;32.12;2.87;N/A;-
-----AA;9.37;0.87;0.12;2011-11-02
-----ABB;17.06;1.33;0.67;2011-05-03
-----ABT;51.11;3.28;1.92;2011-10-12
-----ABX;46.27;3.75;0.49;2011-08-29
-----ACITX;12.9;-;-;-
-----ADM;25.17;3.13;0.64;2011-08-16
-----AHEXY.PK;19.3;1.77;N/A;-
-----AIG;21.36;5.24;N/A;2008-09-03
-----ALU;2.66;0.21;N/A;2006-09-06
-----AOS;32.31;3.35;0.64;2011-07-27
-----APD;79.13;5.37;2.32;2011-09-29
-----ARJ;46.8;2.57;0.8;2011-05-11
-----ASBFY.PK;16.6;1.06;N/A;-
-----ATI;35.4;1.37;0.72;2011-09-16
-----ATK;55.05;9.21;0.8;2011-09-02
-----AU;41.76;1.8;0.24;2011-08-31
-----AXAHY.PK;13.05;-;-;-
-----AZSEY.PK;9.67;1.25;N/A;-
-----BAC;5.77;-1.64;0.04;2011-08-31
-----BASFY.PK;62.85;9.02;N/A;-
-----BAYRY.PK;53.65;2.53;N/A;-
-----BCO;23.95;1.5;0.4;2011-07-15
-----BDX;72.92;5.95;1.64;2011-09-07
-----BEARX;4.89;-;-;-
-----BF-B;69.58;3.95;1.28;2011-09-01
-----BG;57.09;6.83;1;2011-11-16
-----BHP;69.36;8.54;2.2;2011-09-07
-----BK;18.28;2.14;0.52;2011-07-27
-----BMY;32.73;1.93;1.32;2011-10-06
-----BRFS;17.27;0.89;N/A;2011-06-30
-----BRK-B;73.23;7457.95;N/A;-
-----BTU;35.68;3.28;0.34;2011-08-02
-----CAG;24.43;1.76;0.96;2011-10-27
justplainbll is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 10-06-2011, 07:40 AM   #42
Recycles dryer sheets
 
Join Date: Jul 2008
Posts: 141
Quote:
Originally Posted by PaddyMac View Post
Have you looked at Morningstar's Portfolio report? Once you put in all your holdings, it does the tracking. You can add and subtract columns to give you more info. I can't imagine needing more info that that, and we have pretty busy accounts too.
I too get an email from Morningstar that outlines my holdings and their performance.
TN_INVEST is offline   Reply With Quote
Old 10-06-2011, 07:49 AM   #43
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
 
Join Date: Sep 2005
Location: Northern IL
Posts: 26,821
Quote:
Originally Posted by justplainbll View Post
So what's likely to be VWENX's December dividend?
That cap gains distribution is variable, as you know. You can get an idea from past years, and I think you might even be able to get an estimate from Vanguard or other sources, prior to the ex-div date (not sure about that). But, what is the consequence of that?

Does the possible tax consequence outweigh the amount you have under-performed VWENX? What exactly is the goal here?


-ERD50
ERD50 is offline   Reply With Quote
Old 10-09-2011, 06:25 PM   #44
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,266
Quote:
Originally Posted by justplainbll View Post
Thanks for the suggestion. Below is a sample of the data for which I am seeking an alternate source (in the event that the Yahoo provided info ceases to be freely available):

Symbol;Close;EPS(ttm); Div/Shr;Ex-Div

-----A;32.12;2.87;N/A;-
I don't invest in individual stocks, but I did take a quick look at the fields available to view and it appears to me that the information you need is available.

Any individual stock investors on this board who use Quicken who can confirm?
pb4uski is offline   Reply With Quote
Old 10-10-2011, 04:11 AM   #45
Recycles dryer sheets
justplainbll's Avatar
 
Join Date: Sep 2011
Location: Easten Long Island
Posts: 414
Quote:
Originally Posted by pb4uski View Post
I don't invest in individual stocks, but I did take a quick look at the fields available to view and it appears to me that the information you need is available.

Any individual stock investors on this board who use Quicken who can confirm?
Is Quicken free?
justplainbll is offline   Reply With Quote
Old 10-10-2011, 09:11 AM   #46
Thinks s/he gets paid by the post
Rustward's Avatar
 
Join Date: Apr 2006
Posts: 1,684
Let me google that for you

Maybe the online version. They must have felt some pressure from the free competitors.
Rustward is offline   Reply With Quote
Old 10-10-2011, 06:13 PM   #47
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
pb4uski's Avatar
 
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,266
Quote:
Originally Posted by justplainbll View Post
Is Quicken free?
Not familiar with the free version but I presume it is probably the basic version and does not do investment tracking.

$60 as I recall. If it can automate what you need (particularly transactions, dividends reinvested, etc.) and upload info automatically compared to uploading data to Excel I would think it would be a small price to pay, but your call.
pb4uski is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


» Quick Links

 
All times are GMT -6. The time now is 12:34 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.