That's a very vague question.
What about the S&P 500? Current price? Historical quotes? P/E ratio? Constituents? Or something else?
Index or ETF?
What context? One data item, or other data and other tickers?
A couple examples of last price of the index:
=smfStrExtr(RCHGetWebData("https://finance.yahoo.com/quote/^GSPC","""regularMarketPrice"":",100),"""raw"":",",",1)
=smfStrExtr(RCHGetWebData("https://www.barchart.com/stocks/quotes/$SPX/overview","""lastPrice"":",100),":""","""",1)
On Fri, Feb 28, 2020 at 1:44 PM Leo Bueno Leo@... wrote:
I will appreciate seeing the formula for the S&P 500.
If possible would like to see formulas for 2 or 3 data sources (Yahoo, Google, etc.)
__._,_.___
Posted by: Randy Harmelink <rharmelink@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
.
__,_._,___
Tidak ada komentar:
Posting Komentar