Managing stock portfolio in Excel
Public Sub testGoogleFinance()
generalReport restQuery _
(“googlefinance”, “google finance”, , “ticker”, , , , , False) _
- Instruct that the library does not blank out the sheet before populating (the false in the call arguments)
- Leave a blank column between the data to be populated (the yellow), and that to be left alone (the blue), and also a blank row between the data and the total. This will ensure the formulas remain intact.