An overview of my stock market dashboard google sheet which I use to monitor the markets. It is flexible so I can easily change the timeframe to look at short or long term analysis. I look at price movements, compound annual growth rates, and overbought potential relative to a moving average. A screener for the best markets, factors (momentum, value, quality, small cap), S&P 500 sectors and themes. It also looks at the best performing type of bonds and commodities.
The stock market dashboard has ETF data which is updated from global stock exchanges with approximately a 15 minute delay. In this file I use the exchange symbol LON: to pull data from the London Stock Exchange. Link to the file is here https://docs.google.com/spreadsheets/d/17n3zjY3azzYhb6zN61LMdudpqCqLRJXQ_8P9jeGtjSE/edit?usp=sharing Use google finance commands to streamline your analysis