The formula in python will be useful for my use case. I can simply import a package like investpy or openbb then print the output directly into a cell. This will be great, i think.
Automa [0] is just another no-code extension to automate web browser. I used it to scrape excel files from the website of an open-end fund, which does not expose public API for its daily NAV historical data. This extension not only saved me time to manually point and click 1000s of url, but also give me a reason to procrastinate teaching myself selenium.
[0]: https://neuracache.com/