The Google sheet must get the price of certain exchange rates (to the South African ZAR) as well as certain commodities like Gold and Brent Crude Oil on a certain date. I want to insert the date in once cell and then it must be able to fetch all this data using the Google Apps Script as well as GoogleFinace formulae.
1. We require the ZAR exchange rate for USD, GBP, EURO, AUD$,
2. We require the price of GOLD and Brent Crude Oil in USD
3. We require the price of Bitcoin and S&P500 Index in USD
4. The South Africa Inland Fuel Price is at [login to view URL] and we require the price of Diesel (50ppm), Petrol 95 and Petrol 93
5. The South Africa Prime Interest Rate is at [login to view URL]
6. The Inflation Rate (CPI) for every month at [login to view URL]
7. The PPI for every month is at [login to view URL]
See attached sheet as guidance.