SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Greenblatt's Little Book That Beats The Market

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Shane M who wrote (193)3/5/2013 12:52:23 AM
From: Jurgis Bekepuris  Read Replies (1) of 218
 
Shane,

Thanks for describing your process in detail. Maybe I should get AAII Stock Investor Pro.

For now though I started working on using SMF add in to get data from web to my spreadsheets. It has Yahoo/MSN/Google fundamental data. One drawback is that Google/Yahoo/MSN don't necessarily update data really fast after it's released by companies. FCF is limited to OCF-CapEx (there is no easy way to also include acquisitions). I am trying to work out how can I automatically get last partial year results annualized while getting previous years as annual results. This is probably a bit tricky.

International companies and microcaps (pinks) still have to be done manually.

And then I will need to update my 700 spreadsheet files that already have manual data. Since I can't keep the same cell layout, this is gonna be a huge update, although it can be done incrementally. :)

I'll let you know how things go. :)
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext