Google Automate

使用ImportXML與ImportHTML之函數，抓取外部網站之股票即時行情與歷史行情。

透過Google試算表，使用GoogleFinance之函數，達到抓取即時行情與歷史行情的效果。

Google Finance is a function within Google Sheets that fetches current or historical securities information. It helps investors make more informed trading and investment decisions. By using Google Finance, you can create your own watchlists and view real-time market quotes.

This guide provides a method to obtain real-time information without delay. By using the IMPORTXML and IMPORTHTML functions, we can scrape real-time and historical data directly from websites.