https://www.sheetgo.com/blog/google-sheets-formulas/googlefinance-formula-google-sheets/

引用此網址.....的文章

The GOOGLEFINANCE function allows you to import real-time financial and currency market data straight into Google Sheets. It also enables you to track current and historical data for various financial instruments, such as stocks and shares.

This function imports data from the Google Finance web application. This Google tool provides daily stock prices, financial markets news, and analysis of market trends. Google Finance can be accessed from the Google menu like all other Google applications. Alternatively, if you search for a stock on Google, the first result will show you information from Google Finance.

If analysts wanted to gather information on a stock, they would have to visit a financial website or database to access a range of information. After carrying out research, the next step was to compile all that relevant stock information into a spreadsheet for further analysis.

This involved the analyst copying the stock information from the website and pasting it into a spreadsheet. An alternative was to use customized scripts to scrape this information from the web. The first approach is cumbersome, unreliable, and definitely not recommended. And the second method is faster, but it also has drawbacks. Getting a coder to write a script is expensive, time consuming, and not very flexible.

A more reliable and economic alternative to both options is the GOOGLEFINANCE spreadsheet function. If you work with financial market data, this function can automate data retrieval to save you serious time.

有些資料的分布並非呈現常態分布，例如國小的教師所出的平時測驗考高分的人居多，是呈現負偏態的分布。

【偏態(skewness)】:指大部份的數值落在平均數的左邊或右邊。種類有二：
1.正偏態分配(positive skewness):數值較集中在低分部分，即平均數左邊的數值較多，表示考低分的人較多，有可能試題較難或班上能力較差。
2.負偏態分配(negative skewness):其數值較集中在平均數的右邊，表示考高分的人較多，可能是試題較簡單或班上能力較強。
※依據皮爾森近似眾數原理，眾數至中數的距離比上中數至平均數的距離均為2:1，此三種數值，只要知道其中兩種就可以大致推論第三種數值。

【峰度(kurtosis)】:決定數值分布的同質性與異質性，越接近高狹峰表示越同質，越趨向低闊峰表示越異質。種類有二：
1.高狹峰(leptokurtic):次數分配的曲線較常態峰尖峻，其特質是中間的人數比常態峰多，腰部的人數比常態峰少，而兩尾端的人數比常態峰還多。
2.低闊峰(platykurtic):次數分配的曲線較常態峰平坦，但其特色是中間的人數比常態分配少，兩端的人數亦比常態分配少，只有腰身部份的人數多於常態分配。