I have developed different Excel bots to trade cryptocurrencies in different exchanges, via their API. Reading prices does not require to have an account. I am an expert in crypto currencies. Reading the prices of BTC is trivial. Gold price should also not be difficult to find on-line. Many options.
Also, I am aeronautical engineer and MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.