2 Messages
Digest #4446
Messages
Sun Dec 23, 2018 9:47 am (PST) . Posted by:
jeffrdavis
Thanks for looking into this. I'm out of practice with VB but reasonably adept at programming in general, if there's anything I can do to assist in troubleshooting, please let me know. I feel sure that if the OP and myself are experiencing this, there are probably others as well.
In the meantime, for anyone else running into this, you can try the following workaround that should work for mutual funds and ETFs:
=smfStrExtr(RCHGetWebData(CONCAT("https://query1.finance.yahoo.com/v10/finance/quoteSummary/",B56,"?modules=fundProfile";),1,200),"categoryName"":""","""")
where the "B56" in the above formula is a reference to a cell containing a ticker symbol to look up.
In the meantime, for anyone else running into this, you can try the following workaround that should work for mutual funds and ETFs:
=smfStrExtr(RCHGetWebData(CONCAT("https://query1.finance.yahoo.com/v10/finance/quoteSummary/",B56,"
where the "B56" in the above formula is a reference to a cell containing a ticker symbol to look up.
Sun Dec 23, 2018 11:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I have had issues from time to time within the VBA-JSON code, and it's
always a pain. I'm hesitant to make changes in someone else's prepackaged
code. It require more understanding than going through a single debug
process. :(
The method you used below works well for single-occurrence JSON tags. But
in a lot of the JSON files from Yahoo, there are a number of arrayed items.
There is another function I had written before the VBA-JSON code that does
the brute force extraction of some data items from JSON files:
=smfGetYahooJSONData("VFINX","fundprofile","categoryName",,"")
On Sun, Dec 23, 2018 at 10:47 AM n0dyjeff@... wrote:
>
> Thanks for looking into this. I'm out of practice with VB but reasonably
> adept at programming in general, if there's anything I can do to assist in
> troubleshooting, please let me know. I feel sure that if the OP and myself
> are experiencing this, there are probably others as well.
>
> In the meantime, for anyone else running into this, you can try the
> following workaround that should work for mutual funds and ETFs:
>
> =smfStrExtr(RCHGetWebData(CONCAT("
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/
> ",B56,"?modules=fundProfile";),1,200),"categoryName"":""","""")
>
> where the "B56" in the above formula is a reference to a cell containing a
> ticker symbol to look up.
>
>
always a pain. I'm hesitant to make changes in someone else's prepackaged
code. It require more understanding than going through a single debug
process. :(
The method you used below works well for single-occurrence JSON tags. But
in a lot of the JSON files from Yahoo, there are a number of arrayed items.
There is another function I had written before the VBA-JSON code that does
the brute force extraction of some data items from JSON files:
=smfGetYahooJSONData("VFINX","fundprofile","categoryName",,"")
On Sun, Dec 23, 2018 at 10:47 AM n0dyjeff@... wrote:
>
> Thanks for looking into this. I'm out of practice with VB but reasonably
> adept at programming in general, if there's anything I can do to assist in
> troubleshooting, please let me know. I feel sure that if the OP and myself
> are experiencing this, there are probably others as well.
>
> In the meantime, for anyone else running into this, you can try the
> following workaround that should work for mutual funds and ETFs:
>
> =smfStrExtr(RCHGetWebData(CONCAT("
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/
> ",B56,"
>
> where the "B56" in the above formula is a reference to a cell containing a
> ticker symbol to look up.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar