Jumat, 03 Oktober 2014

[smf_addin] Digest Number 3198

15 Messages

Digest #3198
1a
1c
Re: MSM Eliment numbers by "Randy Harmelink" rharmelink
2b
Re: Invalid zip file download by "T Shepherd" tonybshepherd
4a
Stock Splits by zacharycal
4b
Re: Stock Splits by "Kermit W. Prather" kermitpra
4c
Re: Stock Splits by zacharycal
4d
Re: Stock Splits by "Randy Harmelink" rharmelink
4e
Re: Stock Splits by zacharycal
5a
Re: MSN data by copthornelabs

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


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

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?
>

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

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
>
>
>

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

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

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

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.
>

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.

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.

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.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar