Please excuse the imprecision of my question.
As I write (Friday after the markets closed), the value of the S&P index shown at Yahoo (https://finance.yahoo.com/) is 2,972.37.
Yahoo calls the ticker ^GSPC.
I tried using that symbol and . . . it worked!
In other words, this formula
=smfGetYahooPortfolioView("^GSPC","15")
returns the correct value.
If possible, as a backup, I would like to obtain the value from another source besides Yahoo.
Thanks.
Leo
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, February 28, 2020 5:42 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Formula for S&P 500
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: Leo Bueno <leo@buenolaw.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar