15 Messages
Digest #3198
Messages
Fri Oct 3, 2014 4:38 am (PDT) . Posted by:
smmarder
Sorry if this has been answered. For the last few days, none of the MSM eliment numbers I use are comming in I get an "Error" return. No problem on other numbers from Yahoo etc. Examples are 33, 34, 63. 353, 343,347,348,
Is it just me or are others having a problem?
EXCELLENT PROGRAM!!!
Thanks
Sid
Is it just me or are others having a problem?
EXCELLENT PROGRAM!!!
Thanks
Sid
Fri Oct 3, 2014 5:22 am (PDT) . Posted by:
t.palm27
Sid,
I believe the MSN website just changed its data layout and therefore altered the data that Randy's program was pulling from. I think for now the MSN data pulls will be obsolete...just try to use the others (Yahoo, Google, Morningstar) for now until a solution is found.
-Trent
I believe the MSN website just changed its data layout and therefore altered the data that Randy's program was pulling from. I think for now the MSN data pulls will be obsolete...just try to use the others (Yahoo, Google, Morningstar) for now until a solution is found.
-Trent
Fri Oct 3, 2014 8:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031
On Fri, Oct 3, 2014 at 4:38 AM, smmarder@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Sorry if this has been answered. For the last few days, none of the MSM
> eliment numbers I use are comming in I get an "Error" return. No problem on
> other numbers from Yahoo etc. Examples are 33, 34, 63. 353, 343,347,348,
> Is it just me or are others having a problem?
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031
On Fri, Oct 3, 2014 at 4:38 AM, smmarder@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Sorry if this has been answered. For the last few days, none of the MSM
> eliment numbers I use are comming in I get an "Error" return. No problem on
> other numbers from Yahoo etc. Examples are 33, 34, 63. 353, 343,347,348,
> Is it just me or are others having a problem?
>
Fri Oct 3, 2014 6:09 am (PDT) . Posted by:
t.palm27
Is anyone having problems downloading the add-in zip file? I've cleared my browser cache, and download the zip file into a "SMF" folder I created on my C drive. However, when I try to extract it says the zip folder is invalid because it is empty. I've tried numerous times, and I've extracted other zip files just recently on my computer. Any ideas on what I am doing wrong? Thanks
-Trent
-Trent
Fri Oct 3, 2014 6:24 am (PDT) . Posted by:
"T Shepherd" tonybshepherd
Hi Trent - I just tried - worked fine.
Win XP Pro SP3, FF 32.0.3
Downloaded file size 78,892 (764 k on disk)
Used 7-zip to open - no problems.
Did -not- try extracting files.
HTH - regards - Tony
>________________________________
> From: "quickback27@hotmail.com [smf_addin]" <smf_addin@yahoogroups.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, October 3, 2014 9:09 AM
>Subject: [smf_addin] Invalid zip file download
>
>
>
>
>Is anyone having problems downloading the add-in zip file? I've cleared my browser cache, and download the zip file into a "SMF" folder I created on my C drive. However, when I try to extract it says the zip folder is invalid because it is empty. I've tried numerous times, and I've extracted other zip files just recently on my computer. Any ideas on what I am doing wrong? Thanks
>
>
>-Trent
>
>
>
Win XP Pro SP3, FF 32.0.3
Downloaded file size 78,892 (764 k on disk)
Used 7-zip to open - no problems.
Did -not- try extracting files.
HTH - regards - Tony
>________________________________
> From: "quickback27@hotmail.com [smf_addin]" <smf_addin@yahoogroups.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, October 3, 2014 9:09 AM
>Subject: [smf_addin] Invalid zip file download
>
>
>
>
>Is anyone having problems downloading the add-in zip file? I've cleared my browser cache, and download the zip file into a "SMF" folder I created on my C drive. However, when I try to extract it says the zip folder is invalid because it is empty. I've tried numerous times, and I've extracted other zip files just recently on my computer. Any ideas on what I am doing wrong? Thanks
>
>
>-Trent
>
>
>
Fri Oct 3, 2014 7:58 am (PDT) . Posted by:
"Barry B" barryb_nj
Does anyone know if another site picked up StockScouter? Does anyone have
a "similar" metric?
Thank you,
Barry
a "similar" metric?
Thank you,
Barry
Fri Oct 3, 2014 7:59 am (PDT) . Posted by:
zacharycal
Hey Randy,
Is there anyway to import stock split data using RCGGetYahooHistory? I am running historical monthly returns on a variety of ETFs and when I use the adjusted High/Low it can cause some of the numbers (e.g. Max Drawdown, From the Peak) to be off. I would just like to know the dates of the splits so I can default to the adjust close for that month. I tried to create a formula based on the deviation (e.g. 6 sigma = split), but even then I miss some.
Thanks!
Zach
Is there anyway to import stock split data using RCGGetYahooHistory? I am running historical monthly returns on a variety of ETFs and when I use the adjusted High/Low it can cause some of the numbers (e.g. Max Drawdown, From the Peak) to be off. I would just like to know the dates of the splits so I can default to the adjust close for that month. I tried to create a formula based on the deviation (e.g. 6 sigma = split), but even then I miss some.
Thanks!
Zach
Fri Oct 3, 2014 9:17 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I use this formula in an array to get split history.
=RCHGetHTMLTable("http://getsplithistory.com/"&$C$5,"",1,"",1)
Stock symbol is in cell C5 and must be uppercase
The array must be 5 columns and as many rows as you think you need . I use a 5 column by 35 row array and it has always been more than enough.
Split date ▼
Ratio
Price (close)
Price the day before
Change
Nov 26, 2010
2 : 1
$48.82
96.51 (Nov 24)
1.17%
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, October 03, 2014 10:12 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Stock Splits
Hey Randy,
Is there anyway to import stock split data using RCGGetYahooHistory? I am running historical monthly returns on a variety of ETFs and when I use the adjusted High/Low it can cause some of the numbers (e.g. Max Drawdown, From the Peak) to be off. I would just like to know the dates of the splits so I can default to the adjust close for that month. I tried to create a formula based on the deviation (e.g. 6 sigma = split), but even then I miss some.
Thanks!
Zach
=RCHGetHTMLTable("http://getsplithistory.com/"&$C$5,"",1,"",1)
Stock symbol is in cell C5 and must be uppercase
The array must be 5 columns and as many rows as you think you need . I use a 5 column by 35 row array and it has always been more than enough.
Split date ▼
Ratio
Price (close)
Price the day before
Change
Nov 26, 2010
2 : 1
$48.82
96.51 (Nov 24)
1.17%
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, October 03, 2014 10:12 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Stock Splits
Hey Randy,
Is there anyway to import stock split data using RCGGetYahooHistory? I am running historical monthly returns on a variety of ETFs and when I use the adjusted High/Low it can cause some of the numbers (e.g. Max Drawdown, From the Peak) to be off. I would just like to know the dates of the splits so I can default to the adjust close for that month. I tried to create a formula based on the deviation (e.g. 6 sigma = split), but even then I miss some.
Thanks!
Zach
Fri Oct 3, 2014 9:43 am (PDT) . Posted by:
zacharycal
Thanks. That works for stocks, but I need it for ETFs and that one doesn't work for that. Any other ideas?
Fri Oct 3, 2014 10:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I usually get my split data off of the Yahoo basic chart, or from
MorningStar. Search the archives and you'll find it discussed several times.
Otherwise, I see Kermit has offered a different way...
On Fri, Oct 3, 2014 at 7:12 AM, zabrams@... wrote:
>
> Is there anyway to import stock split data using RCGGetYahooHistory? I am
> running historical monthly returns on a variety of ETFs and when I use the
> adjusted High/Low it can cause some of the numbers (e.g. Max Drawdown, From
> the Peak) to be off. I would just like to know the dates of the splits so
> I can default to the adjust close for that month. I tried to create a
> formula based on the deviation (e.g. 6 sigma = split), but even then I miss
> some.
>
MorningStar. Search the archives and you'll find it discussed several times.
Otherwise, I see Kermit has offered a different way...
On Fri, Oct 3, 2014 at 7:12 AM, zabrams@... wrote:
>
> Is there anyway to import stock split data using RCGGetYahooHistory? I am
> running historical monthly returns on a variety of ETFs and when I use the
> adjusted High/Low it can cause some of the numbers (e.g. Max Drawdown, From
> the Peak) to be off. I would just like to know the dates of the splits so
> I can default to the adjust close for that month. I tried to create a
> formula based on the deviation (e.g. 6 sigma = split), but even then I miss
> some.
>
Fri Oct 3, 2014 10:26 am (PDT) . Posted by:
zacharycal
Thanks! I used the Morningstar and it worked great.
Fri Oct 3, 2014 8:36 am (PDT) . Posted by:
copthornelabs
FYI everyone: MSN Stockscouter ratings are powered by Verus Analytics: http://www.verusanalytics.com/partners.jsp
I believe this is a Thompson Reuters company.
The same Stockscouter scores are available on Thompson-Reuters Stockreports that are available to retail clients of TD Ameritrade (there may be other brokerage firms that supply these for free as well - search I dont know). If you use the Thinkpipes product put out by TD Ameritrade I( think you get access to these reports for free.
I believe Fidelity also offers a stock score and it is my understanding that they also use Morningstar data to get these.
There are many stock scoring systems out there. IBD, Barry Ritholz (www.fusioniqrank.com)has one Louis Navellier also has one and most of the major discount brokers have their own versions( see Schwab).
Most everyone of these require a nominal membership or a sign up - I have found these amounts well worth the value supplied in research provided without too much fuss.
Dave C.
I believe this is a Thompson Reuters company.
The same Stockscouter scores are available on Thompson-Reuters Stockreports that are available to retail clients of TD Ameritrade (there may be other brokerage firms that supply these for free as well - search I dont know). If you use the Thinkpipes product put out by TD Ameritrade I( think you get access to these reports for free.
I believe Fidelity also offers a stock score and it is my understanding that they also use Morningstar data to get these.
There are many stock scoring systems out there. IBD, Barry Ritholz (www.fusioniqrank.
Most everyone of these require a nominal membership or a sign up - I have found these amounts well worth the value supplied in research provided without too much fuss.
Dave C.
Fri Oct 3, 2014 8:43 am (PDT) . Posted by:
bigzippy@bellsouth.net
Still does not work for me very weird. So, for symbol MMM i get error and other random symbols any ideas or a diferent source of data?
Fri Oct 3, 2014 8:55 am (PDT) . Posted by:
bigzippy@bellsouth.net
=RCHGetElementNumber("AET";,5897) this is AdvFN-A Annual Income Statement -- Year-to-Date -- Revenue -- FY2
tried different symbols does not work either.
tried different symbols does not work either.
Fri Oct 3, 2014 10:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
AET is a financial company, so the normal "Revenue" line item isn't
something on their financial statements on AdvFN. Financial companies use
different labels, so the element definitions don't apply to them.
Otherwise, have you applied the cross domains option mentioned in the "Tips
and FAQs" item?
Otherwise, a few people have gone to GuruFocus, using the model uploaded to
the Yahoo group's FILES area.
On Fri, Oct 3, 2014 at 8:55 AM, bigzippy@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> =RCHGetElementNumber("AET";,5897) this is AdvFN-A Annual Income Statement
> -- Year-to-Date -- Revenue -- FY2
> tried different symbols does not work either.
>
something on their financial statements on AdvFN. Financial companies use
different labels, so the element definitions don't apply to them.
Otherwise, have you applied the cross domains option mentioned in the "Tips
and FAQs" item?
Otherwise, a few people have gone to GuruFocus, using the model uploaded to
the Yahoo group's FILES area.
On Fri, Oct 3, 2014 at 8:55 AM, bigzippy@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> =RCHGetElementNumbe
> -- Year-to-Date -- Revenue -- FY2
> tried different symbols does not work either.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar