Tip -- Possible Google method to get current quotes

I recently was referred to this web page on "Free Stock Quotes in Excel". Not up-to-date, but the Google method was interesting, so I tried it. For some of you, it might be a good alternative or back-up. The primary drawback is that you would manually need to maintain your ticker list within the Google sheet.

See this web page for data items available from the Google Finance API.

I used the method to publish a CSV file of quotes data for the S&P 500 stocks. To get it into EXCEL, all that is needed is:

=smfGetCSVFile("https://docs.google.com/spreadsheets/d/e/2PACX-1vRVFIQcRFRobB_tnWo-tiVZ9J8s74RExHlQulpumJLWsF1RbmhrfcPs1vZnvAc9-OEqk0tcZKSIGHR9/pub?output=csv")

Seemed fast to me, for data on 500 stocks. The first few lines look like:

Ticker	Tradetime	Price	Change	Change %	Open	High	Low	Volume	Prev Close	52-Wk Low	52-Wk High	PE	EPS
A	11/3/2017 15:44:12	$68.28	$0.15	0.22	$68.09	$68.67	$68.01	765380	$68.13	$42.92	$68.67	35.2	1.94
AAL	11/3/2017 15:44:34	$47.47	$0.11	0.23	$47.36	$47.61	$46.80	2837542	$47.36	$39.21	$54.48	12.08	3.93
AAP	11/3/2017 15:44:28	$81.96	$0.27	0.33	$81.39	$82.38	$80.27	879400	$81.69	$80.21	$177.83	16.37	5.01
AAPL	11/3/2017 15:46:35	$172.61	$4.50	2.68	$174.00	$174.26	$171.12	52786306	$168.11	$104.08	$174.26	19.63	8.79