2 Messages
Digest #4445
Messages
Sat Dec 22, 2018 2:46 pm (PST) . Posted by:
jeffrdavis
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
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)
Result
Large BlendUsing SMF from 2018-01-24 with Excel 2019, 64-bit
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
>
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)
>
> *Result*
>
> Large Blend
>
> Using SMF from 2018-01-24 with Excel 2019, 64-bit
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar