2 Messages

Digest #4445

Re: RCHGetElementNumber() by jeffrdavis

Re: RCHGetElementNumber() by "Randy Harmelink" rharmelink

Messages

1a

I'm having the exact same problem as the original poster. This was working fine until recently. Not sure what has changed.

Formula
=RCHGetElementNumber("VFINX",5059)
Result
Not Found

Formula
=RCHGetElementNumber("Definition",5059)
Result
YahooPro;Fund Profile -- Category;=smfGetYahooJSONField("~~~~~","fundProfile","quoteSummary.result.0.fundProfile.categoryName")
Formula
=RCHGetWebData("https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundProfile https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundProfile",1,200)
Result
{"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
[As far as I can tell, the response is truncated here, but it looks like there should be more]

Formula
=smfStrExtr(RCHGetWebData("https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundProfile https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundProfile",1,200),"categoryName"":""","""")
Result
Large BlendUsing SMF from 2018-01-24 with Excel 2019, 64-bit

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

1b

Re: RCHGetElementNumber()

Sat Dec 22, 2018 2:55 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I still haven't a clue what could be going on. The formula works fine, and
all of the diagnostic formulas you gave me the results of have the correct
results. Without seeing the issue here, there's really no good way for me
to take a closer look at what might be going wrong... :(

If the problem is within JSON extraction, it's not even my code. I'm using
the generally available VBA-JSON code.

On Sat, Dec 22, 2018 at 3:48 PM n0dyjeff@... wrote:

>
> I'm having the exact same problem as the original poster. This was working
> fine until recently. Not sure what has changed.
>
> *Formula*
>
> =RCHGetElementNumber("VFINX",5059)
>
> *Result*
>
> Not Found
>
>
> *Formula*
>
> =RCHGetElementNumber("Definition",5059)
>
> *Result*
>
> YahooPro;Fund Profile --
> Category;=smfGetYahooJSONField("~~~~~","fundProfile","quoteSummary.result.0.fundProfile.categoryName")
>
>
> *Formula*
>
> =RCHGetWebData("
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundProfile
> ",1,200)
>
> *Result*
>
> {"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
>
>
> [As far as I can tell, the response is truncated here, but it looks like
> there should be more]
>
> *Formula*
>
> =smfStrExtr(RCHGetWebData("
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/VFINX?modules=fundProfile
> ",1,200),"categoryName"":""","""")
>
> *Result*
>
> Large Blend
>
> Using SMF from 2018-01-24 with Excel 2019, 64-bit
>