Sabtu, 08 Desember 2018

[smf_addin] Digest Number 4437

8 Messages

Digest #4437
1b
Re: RCHGetElementNumber() by "Randy Harmelink" rharmelink
1d
Re: RCHGetElementNumber() by "Randy Harmelink" rharmelink
2b
Re: Getting Stock Quote from Investing.com by "Randy Harmelink" rharmelink
2d
Re: Getting Stock Quote from Investing.com by "Randy Harmelink" rharmelink

Messages

Fri Dec 7, 2018 6:15 am (PST) . Posted by:

lexstar

I'm still getting "NOT FOUND" as the results

Version is:
Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\Program Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; Local; 1)

Fri Dec 7, 2018 7:53 am (PST) . Posted by:

"Randy Harmelink" rharmelink

What do you get with:

=RCHGetElementNumber("VFINX",5059)
=RCHGetElementNumber("Definition",5059)
=RCHGetWebData("
https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundProfile
",1,200)
=smfStrExtr(RCHGetWebData("
https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundProfile
",1,200),"categoryName"":""","""")

On Fri, Dec 7, 2018 at 7:26 AM lexstar@... wrote:

>
> I'm still getting "NOT FOUND" as the results
>
> Version is:
> Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\Program
> Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; Local; 1)
>
>

Fri Dec 7, 2018 9:02 am (PST) . Posted by:

lexstar

I get these:


Not Found

YahooPro;Fund Profile -- Category;=smfGetYahooJSONField("~~~~~","fundProfile","quoteSummary.result.0.fundProfile.categoryName")

{"quoteSummary":{"result":[{"fundProfile":{"maxAge":1,"styleBoxUrl":"http://us.i1.yimg.com/us.yimg.com/i/fi/3_0stylelargeeq2.gif","family":"Vanguard","categoryName":"Large Blend","legalType":null,"man
Large Blend

Fri Dec 7, 2018 10:07 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but all of the diagnostic formulas I gave you got the results I
would expect, so I'm not sure why you're getting "Not Found" for the result
in the first formula...I'm at a loss.

On Fri, Dec 7, 2018 at 10:17 AM lexstar@... wrote:

>
> I get these:
>
> Not Found
>
> YahooPro;Fund Profile --
> Category;=smfGetYahooJSONField("~~~~~","fundProfile","quoteSummary.result.0.fundProfile.categoryName")
>
> {"quoteSummary":{"result":[{"fundProfile":{"maxAge":1,"styleBoxUrl":"
> http://us.i1.yimg.com/us.yimg.com/i/fi/3_0stylelargeeq2.gif","family":"Vanguard","categoryName":"Large
> Blend","legalType":null,"man
>
> Large Blend
>
>

Fri Dec 7, 2018 2:48 pm (PST) . Posted by:

alankc_mok

Randy,

Thanks for your reply.


Back to my first question about getting data from Investing.com, I have just come across to a problem though. Those data on or before 6 Dec 2018 is working. But those for 7 Dec 2018 I got error message.


Please help.


Regards


Alan

Fri Dec 7, 2018 4:36 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Both of these are working fine for me:

=RCHGetTableCell("
https://www.investing.com/indices/hang-sen-40-historical-data",1,">Dec 07,
2018")
=RCHGetTableCell("
https://www.investing.com/indices/hang-sen-40-historical-data",1,TEXT(C4,">mmm
dd, yyyy"))

I had a serial EXCEL date for Dec 7 in cell C4, so they returned the same
value.

It's possible they might now work if you still have an old copy of the web
pages stored, either via IE caching or by virtue of the add-in having saved
the web page before extracting data. To remove IE caching, you need to
change your Windows Internet Options to always get a fresh copy of a web
page. To remove the add-in's stored copy of a web page, you need to run the
smfForceRecalculation macro (or exit and restart EXCEL, which resets the
VBA environment).

On Fri, Dec 7, 2018 at 3:48 PM alankc_mok@... wrote:

>
> Back to my first question about getting data from Investing.com, I have
> just come across to a problem though. Those data on or before 6 Dec 2018
> is working. But those for 7 Dec 2018 I got error message.
>
>
>

Fri Dec 7, 2018 7:12 pm (PST) . Posted by:

alankc_mok

Randy,

Thanks for your explanation. And it is working now.


I try to get the Last Price of the following option chain https://www.hkex.com.hk/market-data/futures-and-options-prices/single-stock/details?sc_lang=en&product=TCH https://www.hkex.com.hk/market-data/futures-and-options-prices/single-stock/details?sc_lang=en&product=TCH


TCH, Dec-18, 300 Call, Last Price


I used =RCHGetTableCell("https://www.hkex.com.hk/market-data/futures-and-options-prices/single-stock/details?sc_lang=en&product=TCH",-1,">DEC-18",">300.000") , but failed.


Please help to point out my error.


Regards


Alan

Sat Dec 8, 2018 1:01 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The data doesn't exist within the source code of that web page, so there's
nothing there for the add-in to extract. The data is retrieved via a JSON
call and then the web page is built dynamically.

When I displayed the page, this is the JSON call that retrieved the data:

https://www1.hkex.com.hk/hkexwidget/data/getderivativesoption?lang=eng&token=evLtsLsBNAUVTPxtGqVeG85kJ0dcEFutPTr%2b%2bwnni8mdGNKN1c7z3yL87Scr5gQw&ats=TCH&con=122018&fr=null&to=null&qid=1544259162838&callback=jQuery311008614605651657037_1544259153928&_=1544259153933

I can see the parameters for the ticker symbol and date (i.e.
"&ats=TCH&con=122018"), but I have no idea of how the other parameters are
involved in the request for the JSON file.

On Fri, Dec 7, 2018 at 8:12 PM alankc_mok@... wrote:

>
> Thanks for your explanation. And it is working now.
>
> I try to get the Last Price of the following option chain
> https://www.hkex.com.hk/market-data/futures-and-options-prices/single-stock/details?sc_lang=en&product=TCH
>
> TCH, Dec-18, 300 Call, Last Price
>
> I used =RCHGetTableCell("
> https://www.hkex.com.hk/market-data/futures-and-options-prices/single-stock/details?sc_lang=en&product=TCH",-1,">DEC-18",">300.000")
> , but failed.
>
> Please help to point out my error.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 05.32

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)