Sabtu, 15 Agustus 2015

[smf_addin] Digest Number 3488

10 Messages

Digest #3488
2b
Re: China Shanghai Exchange tickers by "Randy Harmelink" rharmelink
2c
Re: China Shanghai Exchange tickers by "Andy Chan" andy_c_chan
3a
Re: Index Quotes by rontom_stl
3b
Re: Index Quotes by "Randy Harmelink" rharmelink
3c
Re: Index Quotes by rontom_stl
4.1
RCHGetElementNumber by samil_beret
4.2
Re: RCHGetElementNumber by "Randy Harmelink" rharmelink
4.3

Messages

Fri Aug 14, 2015 2:46 am (PDT) . Posted by:

rharmelink

I've added a new data source for option quotes to the beta version of the add-in -- the NASDAQ web site. Two new files can be found in the "Works in Progress" folder on the SMF add-in website:



Filename Size Last Modified Description 0-Change-log.html http://ogres-crypt.com/public/0-Change-log.html -- 2015-08-13 10:41 AM
Log of changes made to the add-in or other files. RCH_Stock_Market_Functions-2.1.2015.08.13.zip http://ogres-crypt.com/public/RCH_Stock_Market_Functions-2.1.2015.08.13.zip -- 2015-08-13 10:37 AM
Experimental release with new NASDAQ options quotes retrieval

Bad news:
There are no "fast" data items. Each contract goes to its own web page to get data for the contract. So please use the data source sparingly.
The extraction of available expiration dates and strike prices from the NASDAQ website is convoluted. So smfGetOptionExpirations() and smfGetOptionStrikes() will go to Yahoo if the NASDAQ data source is requested on them. I did that just so the same data source parameter value could exist between the various functions.
Good news:
Greeks are available for both puts and calls (main reason I added the data source)
Options contracts with adjustments should work I added a new function, smfGetNASDAQOptonQuote(), but you can also use the regular smfGetOptionQuotes() function.



Sample function invocations:


=smfGetNASDAQOptionQuote("EBAY1","Call";,"1/15/16",60,"l")
=smfGetOptionQuotes("EBAY1 1/15 2016 $60 Call","l",,"N")



=smfGetNASDAQOptionQuote("EBAY","Put","1/15/16",30,"l")
=smfGetOptionQuotes("EBAY 1/15 2016 $30 Put","l",,"N")


=smfGetOptionQuotes("MMM 8/14 2015 $149 Call","5",,"N")
=smfGetOptionQuotes("MMM 8/14 2015 $149 Put","5",,"N")



Fri Aug 14, 2015 4:11 am (PDT) . Posted by:

andy_c_chan

many thanks. is there any other method then to retrieve last price for Shanghai Stock Exchange quotes? via other sources perhaps but using your functions?

Fri Aug 14, 2015 7:51 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This works for me:

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

...but I'm not sure if the "yfs_l84" search term is different when the
market is open?

On Fri, Aug 14, 2015 at 4:11 AM, andy_c_chan@... wrote:

>
> many thanks. is there any other method then to retrieve last price for
> Shanghai Stock Exchange quotes? via other sources perhaps but using your
> functions?
>

Fri Aug 14, 2015 8:04 am (PDT) . Posted by:

"Andy Chan" andy_c_chan

Many thx!

Sent from my iPhone

> On 14 Aug, 2015, at 10:51 pm, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> This works for me:
>
> =smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=601866.SS","span",-1,"yfs_l84"))
>
> ...but I'm not sure if the "yfs_l84" search term is different when the market is open?
>
>> On Fri, Aug 14, 2015 at 4:11 AM, andy_c_chan@... wrote:
>>
>> many thanks. is there any other method then to retrieve last price for Shanghai Stock Exchange quotes? via other sources perhaps but using your functions?
>
>

Fri Aug 14, 2015 4:28 pm (PDT) . Posted by:

rontom_stl

This function works great for me and thanks for posting! I would like to use the "NOW()" function so that "F9" would return the ^dji each time it was pressed. Can someone show me where this should be included in the original function?

=VALUE(RIGHT(smfConvertData(smfGetTagContent("http://finance.yahoo.com/marketupdate/overview","span",-1,"_l84_^dji")),9))

THANKS, Ron T.

Fri Aug 14, 2015 4:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

In order for F9 to update that function, it would need to generate a new
URL for each attempt. So, I'd suggest adding a a cell, say D3, that has the
NOW() formula. Then, you'd need to append that cell to the URL, with
something like:

=smfConvertData(smfGetTagContent("
http://finance.yahoo.com/marketupdate/overview?r=
"&$D$3,"span",-1,"_l84_^dji"))

Do you find you need the VALUE() and RIGHT() functions? The above, without
them, works fine for me. You probably shouldn't use NOW() in the formula
itself, because if you use multiple formulas like that that use the same
web page, each of them would end up generating a separate web page request.
That can really slow down a workbook's update speed.

On Fri, Aug 14, 2015 at 11:09 AM, rontom_stl@... wrote:

>
> This function works great for me and thanks for posting! I would like to
> use the "NOW()" function so that "F9" would return the ^dji each time it
> was pressed. Can someone show me where this should be included in the
> original function?
>
> =VALUE(RIGHT(smfConvertData(smfGetTagContent("
> http://finance.yahoo.com/marketupdate/overview
> ","span",-1,"_l84_^dji")),9))
>
>

Fri Aug 14, 2015 6:15 pm (PDT) . Posted by:

rontom_stl

Thanks for the help and suggestion!

Fri Aug 14, 2015 4:29 pm (PDT) . Posted by:

samil_beret

I just started using RCHGetElementNumber function. I can not find the element number for: Yahoo Analyst Opnion Mean Recommendation (this week). Thanks for your help
S Beret

Fri Aug 14, 2015 4:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There's not an element defined for that. But you can extract it yourself
with something like:

=RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM",1,"Mean
Recommendation (this week):")

...or, if you want to have the ticker symbol in another worksheet cell:

=RCHGetTableCell("http://finance.yahoo.com/q/ao?s="&C7,1,"Mean
Recommendation (this week):")

On Fri, Aug 14, 2015 at 1:44 PM, sberet@... wrote:

> I just started using RCHGetElementNumber function. I can not find the
> element number for: Yahoo Analyst Opnion Mean Recommendation (this week).
> Thanks for your help
>
>

Fri Aug 14, 2015 5:49 pm (PDT) . Posted by:

samil_beret

Thank you very much for your solution. S Beret
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar