Sabtu, 16 Agustus 2014

[smf_addin] Digest Number 3151

14 Messages

Digest #3151
1b
1c
3b
Re: MSN Earnings Growth Rates by "Randy Harmelink" rharmelink

Messages

Fri Aug 15, 2014 5:43 am (PDT) . Posted by:

jurisdoctor74

By way of encouragement for revisiting the MSN option data issue -- if I'm not mistaken, Peter Hoadley of Hoadley Trading uses MSN as his primary "free" source for obtaining option chains so it's likely there does exist some method for extracting that data. (Maybe all we need is some help from a competent encryption expert!)

Fri Aug 15, 2014 5:46 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I THINK WE ALREADY HAVE ONE

BUT LET US KNOW WHEN YOU SOLVE HOW TO DO IT.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, August 15, 2014 8:43 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Problem with Yahoo Option Expiration Command


By way of encouragement for revisiting the MSN option data issue -- if I'm not mistaken, Peter Hoadley of Hoadley Trading uses MSN as his primary "free" source for obtaining option chains so it's likely there does exist some method for extracting that data. (Maybe all we need is some help from a competent encryption expert!)

Fri Aug 15, 2014 8:44 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm open to suggestions. Here's what I have:

126.2.MMM4HGC075000

...has a number of different fields:

"126.2" = I have no idea what this prefix is. It does appear to be constant
though, so may not be an issue.
"MMM" = Ticker symbol of Equity
"4" = Appears to be the year. That is, 4 = 2014, 5 = 2015, 6 = 2016.
"H" = Expiration month. A thru L = Jan thru Dec Calls. M thru X = Jan thru
Dec Puts.
"G" = Expiration day, extracted from numbers then letters,
"123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ".
"C" = I have no idea what this is. It does appear to be constant though, so
may not be an issue.
"075000" = strike price (times one thousand).

However, AAPL has "126.2.AAPL74HGC050000" -- what's the "7" after AAPL? At
first I thought it might be the "10 share per contract" thingie, but it's
on ALL the listings for AAPL.for 8/16 (i.e. the "4HG"). Yahoo has options
for both "AAPL" and "AAPL7" contracts.

Same with AMZN -- 8/16 is all "AMZN7", but Yahoo has AMZN and AMZN7 options.

SPY also has all "SPY7" and none of the volume or open interest are
anywhere near any contracts on Yahoo. But does match the open interest on
the SPY mini-options on OptionsXPress. So, it looks like MSN is only
listing the mini-options for SPY and Yahoo is only listing the regular
options for SPY.

Confusion abounds. Does this mean that equities with mini-options ONLY have
the mini-options listed on MSN?

On Fri, Aug 15, 2014 at 5:43 AM, jurisdoctor74@... wrote:

>
> By way of encouragement for revisiting the MSN option data issue -- if I'm
> not mistaken, Peter Hoadley of Hoadley Trading uses MSN as his primary
> "free" source for obtaining option chains so it's likely there does exist
> some method for extracting that data. (Maybe all we need is some help from
> a competent encryption expert!)
>

Fri Aug 15, 2014 8:46 am (PDT) . Posted by:

chaim422

Hi,Using the RCHGetYahooQuotes() function with the 'k1' field (last, ECN) which used to be real time is now returning the same price as 'l1' which is the delayed price. (I tried ticker EGY and REX; comparing it to Nasdaq real time quotes.) Is there still a way to get real time quotes?Thanks!

Fri Aug 15, 2014 8:52 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo moved from ECN to BATS some time ago. I left the fields there in case
they started to use them again. I think they've just been filling in the
delayed quotes instead.

However, as I understand it, Yahoo dropped their real-time quotes plan
earlier this year, so I'm not expecting anything on that horizon. It was my
understanding that if you had their real-time quotes plan, even the "l1"
and "d1" fields were real-time.

On Fri, Aug 15, 2014 at 8:13 AM, chaim422@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi,Using the RCHGetYahooQuotes() function with the 'k1' field (last, ECN)
> which used to be real time is now returning the same price as 'l1' which is
> the delayed price. (I tried ticker EGY and REX; comparing it to Nasdaq real
> time quotes.) Is there still a way to get real time quotes?Thanks!
>

Fri Aug 15, 2014 8:58 am (PDT) . Posted by:

chaim422

Thanks. I don't have a Yahoo subscription. Is there any way to get free real time quotes?

Fri Aug 15, 2014 9:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can try to extract them yourself if you have a data source. But it will
be slow if you have to get a web page for each ticker symbol. For example,
this works right now for Yahoo:

=smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=MMM
","span",-1,"yfs_l84_"))

However, it's not reliable, because Yahoo appears to change that search
string label from time to time, and I think it even varies depending on
whether the market is open, or it's before the market opens, or after the
market closes.

On Fri, Aug 15, 2014 at 8:58 AM, chaim422@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks. I don't have a Yahoo subscription. Is there any way to get free
> real time quotes?
>

Fri Aug 15, 2014 9:13 am (PDT) . Posted by:

chaim422

Thanks. I like the table of most recent trades from REX American Resources Corporation (REX) Real-Time Stock Quote - NASDAQ.com http://www.nasdaq.com/symbol/rex/real-time What would be the simplest way to pull that?

http://www.nasdaq.com/symbol/rex/real-time

REX American Resources Corporation (REX) Real-Ti... http://www.nasdaq.com/symbol/rex/real-time REX Real Time Stock Quote - Get REX American Resources Corporation (REX) last sale data in real-time at NASDAQ.com.



View on www.nasdaq.com http://www.nasdaq.com/symbol/rex/real-time
Preview by Yahoo



Fri Aug 15, 2014 9:22 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("http://www.nasdaq.com/symbol/rex/real-time","NLS
Time",-1,"",1)

The individual items of the first row of data could be gotten with:

=RCHGetTableCell("http://www.nasdaq.com/symbol/rex/real-time",1,"NLS
Time","<tr")
=RCHGetTableCell("http://www.nasdaq.com/symbol/rex/real-time",2,"NLS
Time","<tr")
=RCHGetTableCell("http://www.nasdaq.com/symbol/rex/real-time",3,"NLS
Time","<tr")

On Fri, Aug 15, 2014 at 9:13 AM, chaim422@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks. I like the table of most recent trades from REX American
> Resources Corporation (REX) Real-Time Stock Quote - NASDAQ.com
> <http://www.nasdaq.com/symbol/rex/real-time> What would be the simplest
> way to pull that?
>

Fri Aug 15, 2014 9:01 am (PDT) . Posted by:

rr76012

Hi Randy,
8-15-2014

FYI, for MSN Earnings Growth Rates --Company.

For rchgetelementnumbers 439:443, I get "NA", =RCHGetElementNumber("MCD";,B443).

I am using rchgetelementnumber definitions as of 2014-01-03.

I was looking for analyst next 5 year eps forecast rchgetelementnumbers.

Have a great weekend.
rr76012

Fri Aug 15, 2014 9:43 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

How about from MorningStar or Yahoo or Zacks, seen in context here:

http://ogres-crypt.com/SMF/Templates/SMF-Template-Morningstar-Stock-Data.xls
http://ogres-crypt.com/SMF/Templates/SMF-Template-Yahoo-Analyst-Estimates.xls
http://ogres-crypt.com/SMF/Templates/SMF-Template-Zacks-Data.xls

On Fri, Aug 15, 2014 at 9:01 AM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> 8-15-2014
>
> FYI, for MSN Earnings Growth Rates --Company.
>
> For rchgetelementnumbers 439:443, I get "NA",
> =RCHGetElementNumber("MCD";,B443).
>
> I am using rchgetelementnumber definitions as of 2014-01-03.
>
> I was looking for analyst next 5 year eps forecast rchgetelementnumbers.
>
>
>

Fri Aug 15, 2014 10:32 am (PDT) . Posted by:

rr76012

Hi Randy,

8-45-2014

Thank you.

I downloaded all 3.

I am going to use all 3 of the 5 year eps growth estimates then average them for my eps growth rate estimate.

Thank you, have a great weekend.

rr76012

Fri Aug 15, 2014 9:24 am (PDT) . Posted by:

digsupply

Hi againIn fact what I am doing is a trick, as you may have noticed. You can't place a FormualaArray in a table, so first I unlist the table (ActiveSheet.ListObjects(1).Unlist), second I insert the FormulaArray, then I paste the values and finally I insert the table again. That way I manage to sort by different headers.I have never used the smfUpdateDownloadTable macro, I don't even know where it is, but thanks for the idea, I will look into it
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.23

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)