3 Messages
Digest #3240
Messages
Sat Nov 15, 2014 11:03 am (PST) . Posted by:
thealphainvestor
Randy,
That is quite unfortunate! I used it extensively in a custom built screening system. Can you think of a suitable substitute for the extensive data that screener allowed us to export and pull into SMF?
Bruce
That is quite unfortunate! I used it extensively in a custom built screening system. Can you think of a suitable substitute for the extensive data that screener allowed us to export and pull into SMF?
Bruce
Sat Nov 15, 2014 12:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The Zack's screener allows quite a bit of data on an export, but I've had
limited (and sporadic) success in automating the process.
But you could always do the export manually, and use VLOOKUP() functions to
extract required data from the export.
Or, instead of a custom built screening system, why not use something like
Portfolio123 for screening? If it provides profitable choices, the monthly
cost should be easy to bear. I used to pay a heck of a lot more just for
the brokerage fee when I traded a single stock.
On Sat, Nov 15, 2014 at 11:49 AM, the.alpha.investor@...wrote:
>
>
> That is quite unfortunate! I used it extensively in a custom built
> screening system. Can you think of a suitable substitute for the extensive
> data that screener allowed us to export and pull into SMF?
>
limited (and sporadic) success in automating the process.
But you could always do the export manually, and use VLOOKUP() functions to
extract required data from the export.
Or, instead of a custom built screening system, why not use something like
Portfolio123 for screening? If it provides profitable choices, the monthly
cost should be easy to bear. I used to pay a heck of a lot more just for
the brokerage fee when I traded a single stock.
On Sat, Nov 15, 2014 at 11:49 AM, the.alpha.investor@
>
>
> That is quite unfortunate! I used it extensively in a custom built
> screening system. Can you think of a suitable substitute for the extensive
> data that screener allowed us to export and pull into SMF?
>
Sat Nov 15, 2014 12:44 pm (PST) . Posted by:
thealphainvestor
Randy,
Thanks. I will see what I can pull out of the Zacks screener. Good suggestion.
I occasionally use web-based screening systems, but I have quite a bit of custom screening logic built. For example, I have calculated Graham Number, and Graham Intrinsic Value, and the Margin of Safety using both. I have also built a customized Smart Beta / Factor Analysis system. It also has a Graham style NCAV / Net Net screener. It does make extensive use of Vlookup because I am pulling data from FinViz using your SMF system, and Yahoo and a couple of other sources using alternative methods. My system is flexible depending on what stage of the market cylce we are in. During the depths of the Great Recession I was screening for deep value dividend stocks. Other times I screen for GARP stocks - Growth at a Reasonable Price.
Thanks for all you do to support this great SMF add-in tool.
Bruce
Thanks. I will see what I can pull out of the Zacks screener. Good suggestion.
I occasionally use web-based screening systems, but I have quite a bit of custom screening logic built. For example, I have calculated Graham Number, and Graham Intrinsic Value, and the Margin of Safety using both. I have also built a customized Smart Beta / Factor Analysis system. It also has a Graham style NCAV / Net Net screener. It does make extensive use of Vlookup because I am pulling data from FinViz using your SMF system, and Yahoo and a couple of other sources using alternative methods. My system is flexible depending on what stage of the market cylce we are in. During the depths of the Great Recession I was screening for deep value dividend stocks. Other times I screen for GARP stocks - Growth at a Reasonable Price.
Thanks for all you do to support this great SMF add-in tool.
Bruce
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar