[smf_addin] Digest Number 3820

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3820

1a

how to retrieve data form stockearning.com by zeeshanmudassir

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

1a

how to retrieve data form stockearning.com

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"

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: how to retrieve data form stockearning.com

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

smfGetOptionQuotes

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (24) . Top ^

2b

Re: smfGetOptionQuotes

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (24) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 14

• Privacy • Unsubscribe • Terms of Use