How to download financial stock data from Google Finance to Google Sheets

Crystal X
7 min readAug 6, 2021

One thing that many people are interested in is how to forecast the movement of the stock market, which is a very tricky art indeed. A person has to make the prediction right, otherwise he risks losing a lot of money if he makes a faulty prediction. Many fund managers are very intuitive in making predictions, which is why they make a lot of money for their skill. More and more, however, people are relying on artificial intelligence to predict on stock prices, which requires those individuals who want to pursue that path to know a little bit about technology if they cannot afford to pay someone to manage their funds for them.

According to the photo I chose to represent this post, there are two basic types of markets, the bull market and a bear market. To put it succinctly, a bull market occurs when securities are on the rise and this is a good time to sell stocks for a profit. A bear market occurs when securities fall for a sustained period of time, and this is a good time to buy stock in the hope that their price will rise sometime in the future.

Of course, world circumstances will inevitably affect the stock market. For example, the recent Coronavirus pandemic has adversely affected stock prices in some areas and boosted them in others. The travel, tourism and hospitality industries were…

--

--

Crystal X

I have over five decades experience in the world of work, being in fast food, the military, business, non-profits, and the healthcare sector.