Sabtu, 15 Oktober 2016

[smf_addin] Digest Number 3820

4 Messages

Digest #3820
1b
Re: how to retrieve data form stockearning.com by "Randy Harmelink" rharmelink
2a
smfGetOptionQuotes by markknutson2005
2b
Re: smfGetOptionQuotes by "Randy Harmelink" rharmelink

Messages

Fri Oct 14, 2016 11:59 am (PDT) . Posted by:

zeeshanmudassir

i was trying to get data from Apple Earnings Date, Apple Earnings Release Date - AAPL | StocksEarning.com http://stocksearning.com/q.aspx?Sys=aapl


Apple Earnings Date, Apple Earnings Release Date - AAPL | StocksEarning.com http://stocksearning.com/q.aspx?Sys=aapl Find Historical price reaction in Earnings report, proprietary predictive volatility indicator, and upcoming Earnings call date for Apple Inc (AAPL) at StocksEarning.com



View on stocksearning.com http://stocksearning.com/q.aspx?Sys=aapl
Preview by Yahoo




but i couldnt.. can somebody help because i want the whole table with "Historical Price Change in Earnings"

Fri Oct 14, 2016 12:05 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, it's not an HTML table, so you'll need to extract each item
individually to construct your table. The general formula is something like:

=smfGetTagContent("http://stocksearning.com/q.aspx?Sys=aapl","span",1,"Historical
Price Change",,,,1)

Vary that first "1" parameter from 1 to 7 for the first row of the table,
from 8 to 14 for the second row of the table, and so on...

On Fri, Oct 14, 2016 at 11:34 AM, zeeshanmudassir@
​...wrote:

>
> i was trying to get data from Apple Earnings Date, Apple Earnings Release
> Date - AAPL | StocksEarning.com <http://stocksearning.com/q.aspx?Sys=aapl>
>
> but i couldnt.. can somebody help because i want the whole table with "Historical
> Price Change in Earnings"
>
>

Fri Oct 14, 2016 2:28 pm (PDT) . Posted by:

markknutson2005

Randy, I am typing the following command in but it doesn't come out as expected:


=smfGetOptionQuotes("hain oct 2016 37 Call","a",0,"G")



It comes out blank.


When it type with november expiration it works as expected. The following works:


=smfGetOptionQuotes("hain nov 2016 37 Call","a",0,"G")



Any advice on how I can get the options ask for october?


Thanks in Advance, Mark


Fri Oct 14, 2016 2:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You'll need to use a different data source. Google doesn't have any HAIN
options listed for October.

On Fri, Oct 14, 2016 at 2:28 PM, mknu@
​...wrote:

> Randy, I am typing the following command in but it doesn't come out as
> expected:
>
> =smfGetOptionQuotes("hain oct 2016 37 Call","a",0,"G")
>
> It comes out blank.
>
> When it type with november expiration it works as expected. The following
> works:
>
> =smfGetOptionQuotes("hain nov 2016 37 Call","a",0,"G")
>
> Any advice on how I can get the options ask for october?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar