4 Messages
Digest #4465
Messages
Sun Jan 20, 2019 7:14 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Barchart locked up their API files a few months ago, so not a viable data
source these days.
I would suggest using smfGetYahooPortfolioView().
On Sun, Jan 20, 2019 at 4:38 AM alankc_mok@... wrote:
>
> As to Stock quote and Stock Option Quote, may I ask what are the site
> that have more accessible data while I don't mind to pay for a nominal
> subscription fee ? Will it be Barchart ?
>
>
>
source these days.
I would suggest using smfGetYahooPortfoli
On Sun, Jan 20, 2019 at 4:38 AM alankc_mok@.
>
> As to Stock quote and Stock Option Quote, may I ask what are the site
> that have more accessible data while I don't mind to pay for a nominal
> subscription fee ? Will it be Barchart ?
>
>
>
Sun Jan 20, 2019 6:44 pm (PST) . Posted by:
alankc_mok
Randy,
Thanks for your reply.
I try to get the SMA 10 from Astocks using
=smfGetTagContent("http://www.aastocks.com/en/stocks/quote/detail-quote.aspx?symbol=0700","td",1,"SMA 10",,,,1)
but fail.
Should I use other addin in order to get the data ?
Regards
Alan
Thanks for your reply.
I try to get the SMA 10 from Astocks using
=smfGetTagContent("http://www.aastocks.com/en/stocks/quote/detail-quote.aspx?symbol=0700","
but fail.
Should I use other addin in order to get the data ?
Regards
Alan
Sun Jan 20, 2019 7:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm getting inconsistent results from the website. Sometimes it returns
data. Other times, it puts up a page asking for the ticker symbol to be
entered. Note that your URL below is incorrect. Right now, this works for
me:
=smfGetTagContent("
http://www.aastocks.com/en/stocks/quote/detail-quote.aspx?symbol=00700","td",1,"SMA
10",,,,1)
....but it didn't earlier.
On Sun, Jan 20, 2019 at 7:44 PM alankc_mok@... wrote:
>
> I try to get the SMA 10 from Astocks using
> =smfGetTagContent("
> http://www.aastocks.com/en/stocks/quote/detail-quote.aspx?symbol=0700","td",1,"SMA
> 10",,,,1)
> but fail.
>
> Should I use other addin in order to get the data ?
>
>
>
data. Other times, it puts up a page asking for the ticker symbol to be
entered. Note that your URL below is incorrect. Right now, this works for
me:
=smfGetTagContent("
http://www.aastocks.com/en/stocks/quote/detail-quote.aspx?symbol=00700","td",1,"SMA
10",,,,1)
....but it didn't earlier.
On Sun, Jan 20, 2019 at 7:44 PM alankc_mok@... wrote:
>
> I try to get the SMA 10 from Astocks using
> =smfGetTagContent("
> http://www.aastocks.com/en/stocks/quote/detail-quote.aspx?symbol=0700","
> 10",,,,
> but fail.
>
> Should I use other addin in order to get the data ?
>
>
>
Sun Jan 20, 2019 9:38 pm (PST) . Posted by:
mff2805
hi Randy,
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")
thanks much
Mike
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","
thanks much
Mike
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar