Many trading applications start with reliable access to data. There are numerous providers one of which is EODHistorical Data.com, providing convenient access to over 70 world wide security exchanges. This API can be used with any programming language, including Excel. This tutorial demonstartes one of their endpoints and the convenient Python helper library to determine the time a stock trades at its low and high each day.
The data API used in the video is free to use, however you are limited to 20 API calls/day. If you find that you like the service and need more API calls, I have arranged for special pricing at this link (I earn a referral fee if you sign up for a paid account): https://eodhistoricaldata.com/alphabench