5 Messages
Digest #4466
Messages
Mon Jan 21, 2019 8:49 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but those items aren't within the source code of the URL you are
using. They are retrieved from QuoteMedia via a script that is protected,
and then placed onto the web page when it is rendered by a browser.
On Sun, Jan 20, 2019 at 10:38 PM mff3429@... wrote:
> I'm trying to get he LAst Price and Last Trade from a page using these
> formula, but an getting an Error response.
>
> Any ideas. just when i think i know how to craft my own functions, i get
> stuck. The way i understand the folruma is: find the prhase "Last
> Price" on the page.
>
> got forward one "td" tag and return its value.
>
> How do you "read" the formula?
>
> =smfGetTagContent("
> https://navelliergrowth.investorplace.com/portfolio-grader/stock-report?q=MMM","td",1,"Last
> Price")
>
> =smfGetTagContent("
> https://navelliergrowth.investorplace.com/portfolio-grader/stock-report?q=MMM","td",1,"Last
> Trade")
>
>
>
using. They are retrieved from QuoteMedia via a script that is protected,
and then placed onto the web page when it is rendered by a browser.
On Sun, Jan 20, 2019 at 10:38 PM mff3429@... wrote:
> I'm trying to get he LAst Price and Last Trade from a page using these
> formula, but an getting an Error response.
>
> Any ideas. just when i think i know how to craft my own functions, i get
> stuck. The way i understand the folruma is: find the prhase "Last
> Price" on the page.
>
> got forward one "td" tag and return its value.
>
> How do you "read" the formula?
>
> =smfGetTagContent("
> https://navelliergrowth.investorplace.com/portfolio-grader/stock-report?q=MMM","td",1,"Last
> Price")
>
> =smfGetTagContent("
> https://navelliergrowth.investorplace.com/portfolio-grader/stock-report?q=MMM","
> Trade")
>
>
>
Mon Jan 21, 2019 9:30 pm (PST) . Posted by:
iroc158
Is this function still working? Two weeks ago, I would get good pricing data, then "--", back to good data, but since Jan 18th just "--" displays. I tried stepping thru the VBA code, and it seems the server URL isn't being found. Using version 2.1.2017.11.04
Mon Jan 21, 2019 9:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's working fine for me.
It can go wonky if you have an invalid symbol in the list. Yahoo doesn't
always act gracefully in that case. Did you try the template to see if it
works?
Also, note that there has been more than one change to that function since
2017.11.04...
On Mon, Jan 21, 2019 at 10:30 PM iroc158@.. wrote:
>
> Is this function still working? Two weeks ago, I would get good pricing
> data, then "--", back to good data, but since Jan 18th just "--" displays.
> I tried stepping thru the VBA code, and it seems the server URL isn't being
> found. Using version 2.1.2017.11.04
>
>
>
It can go wonky if you have an invalid symbol in the list. Yahoo doesn't
always act gracefully in that case. Did you try the template to see if it
works?
Also, note that there has been more than one change to that function since
2017.11.04..
On Mon, Jan 21, 2019 at 10:30 PM iroc158@.. wrote:
>
> Is this function still working? Two weeks ago, I would get good pricing
> data, then "--"
> I tried stepping thru the VBA code, and it seems the server URL isn't being
> found. Using version 2.1.2017.11.
>
>
>
Mon Jan 21, 2019 10:40 pm (PST) . Posted by:
iroc158
Then it has to be on my end! I tried the newest version of the SMF add-in, templates from several backups, and a new simple spreadsheet with only one good ticker symbol to lookup. I also reloaded
Excel, to no avail. FWIW: The RCHGetElementNumber function does work, so I'll keep trying to debug.
Thank you for confirming that indeed the Yahoo! data feed and your function aren't the problem!
Excel, to no avail. FWIW: The RCHGetElementNumber function does work, so I'll keep trying to debug.
Thank you for confirming that indeed the Yahoo! data feed and your function aren't the problem!
Mon Jan 21, 2019 11:58 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
What do you get with:
=smfGetYahooPortfolioView("MMM","15")
=RCHGetWebData("
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM
")
On Mon, Jan 21, 2019 at 11:49 PM iroc158@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Then it has to be on my end! I tried the newest version of the SMF
> add-in, templates from several backups, and a new simple spreadsheet with
> only one good ticker symbol to lookup. I also reloaded
> Excel, to no avail. FWIW: The RCHGetElementNumber function does work, so
> I'll keep trying to debug.
> Thank you for confirming that indeed the Yahoo! data feed and your
> function aren't the problem!
>
>
>
=smfGetYahooPortfolioView("MMM","15")
=RCHGetWebData("
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM
")
On Mon, Jan 21, 2019 at 11:49 PM iroc158@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Then it has to be on my end! I tried the newest version of the SMF
> add-in, templates from several backups, and a new simple spreadsheet with
> only one good ticker symbol to lookup. I also reloaded
> Excel, to no avail. FWIW: The RCHGetElementNumber function does work, so
> I'll keep trying to debug.
> Thank you for confirming that indeed the Yahoo! data feed and your
> function aren't the problem!
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar