必须学的技术:用 Excel 和 Google Sheets 自动快速抓股票数据

 视频在下面,值得一看。视频下方是 Google Sheets 里面能抓到的数据点。

如果视频框不显示,请点这里:https://youtu.be/jNQ_n1SOHjI 


下面是 Google Sheets 里面能抓到的数据点,分为三类。

第一,有哪些实时指标? "price" - Real-time price quote, delayed by up to 20 minutes. "priceopen" - The price as of market open. "high" - The current day's high price. "low" - The current day's low price. "volume" - The current day's trading volume. "marketcap" - The market capitalization of the stock. "tradetime" - The time of the last trade. "datadelay" - How far delayed the real-time data is. "volumeavg" - The average daily trading volume. "pe" - The price/earnings ratio. "eps" - The earnings per share. "high52" - The 52-week high price. "low52" - The 52-week low price. "change" - The price change since the previous trading day's close. "beta" - The beta value. "changepct" - The percentage change in price since the previous trading day's close. "closeyest" - The previous day's closing price. "shares" - The number of outstanding shares. "currency" - The currency in which the security is priced. Currencies don't have trading windows, so open, low, high, and volume won't return for this argument.

第二,有哪些历史指标? "open" - The opening price for the specified date(s). "close" - The closing price for the specified date(s). "high" - The high price for the specified date(s). "low" - The low price for the specified date(s). "volume" - The volume for the specified date(s). "all" - All of the above.

第三,有哪些基金指标? "closeyest" - The previous day's closing price. "date" - The date at which the net asset value was reported. "returnytd" - The year-to-date return. "netassets" - The net assets. "change" - The change in the most recently reported net asset value and the one immediately prior. "changepct" - The percentage change in the net asset value. "yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number. "returnday" - One-day total return. "return1" - One-week total return. "return4" - Four-week total return. "return13" - Thirteen-week total return. "return52" - Fifty-two-week (annual) total return. "return156" - 156-week (3-year) total return. "return260" - 260-week (5-year) total return. "incomedividend" - The amount of the most recent cash distribution. "incomedividenddate" - The date of the most recent cash distribution. "capitalgain" - The amount of the most recent capital gain distribution. "morningstarrating" - The Morningstar "star" rating. "expenseratio" - The fund's expense ratio.


Comments