[smf_addin] Digest Number 3895[1 Attachment]

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3895

1a

Option Chains by jamesbparker999

1b

Re: Option Chains by garyhartling

2a

Re: GetElementNumber 850 (Zacks Industry classification)? by sjagers

3a

Re: Yahoo stock statistics data retrieval? by oldabuelo

4

Anyone please help me on getting this table? Tried RCHgethtmltable b by perseuslim11

Messages

1a

Option Chains

Thu Jan 19, 2017 10:54 am (PST) . Posted by:

jamesbparker999

Hi, long term member but first post ...


I have managed to download the add-in and run some of the templates ... which are a great piece of work!


I cannot spot it directly, but before I re-invent the wheel, I was wondering if there is a template or other file that simply imports all the Options Chains for every expiry for a selected Ticker.


Any help greatly appreciated ...


Cheers
James

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

1b

Re: Option Chains

Thu Jan 19, 2017 11:29 am (PST) . Posted by:

garyhartling

No, but you might use, as a starting point, the template: RCHGetHTMLTable-Template-Yahoo-Options.xls http://ogres-crypt.com/SMF/Templates/RCHGetHTMLTable-Template-Yahoo-Options.xls which will capture the first 14 option chains for a particular ticker for the next monthly expiration for both Calls and Puts. If you need more than 14 strikes you would need to array enter the starting cell, e.g. B4 for Calls, over a longer array.


--Gary H.

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

2a

Re: GetElementNumber 850 (Zacks Industry classification)?

Thu Jan 19, 2017 6:02 pm (PST) . Posted by:

sjagers

Thanks Randy. I appreciate the info.

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

3a

Re: Yahoo stock statistics data retrieval?

Fri Jan 20, 2017 1:19 am (PST) . Posted by:

oldabuelo

Thank you guys .... appears I have what I need .... will work with it this weekend ....

Old Abuelo

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

4

Anyone please help me on getting this table? Tried RCHgethtmltable b

Fri Jan 20, 2017 1:30 am (PST) . Posted by:

perseuslim11

Hi guys, can anyone teach me how to get table from this link?
http://klse.i3investor.com/servlets/stk/fin/7087.jsp?type=last10fy http://klse.i3investor.com/servlets/stk/fin/7087.jsp?type=last10fy





I was using the RCHgetHTMLtable function to pull the data however its not working even though I've tried numerous alterations to the formula..


Formula I've used is
=RCHGetHTMLTable("http://klse.i3investor.com/servlets/stk/fin/"&$E$1&".jsp?type=last10fy","Revenue
",-1,"",1)

My table in excel appears blank like this: (attachment)




I think the problem lies with the "?type=last10fy" part
any way to get around this problem?


Many thanks in advance to thise kind souls who'd help me on this =)




and to Randy, hope that you'd recover to the pink of health soon!! A nice person like you would definitely be blessed by the Almighty God :)

Attachment(s) from

1 of 1 Photo(s)

blank table.png

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

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

Visit Your Group

• New Members 12

• Privacy • Unsubscribe • Terms of Use