I have set my workbook to retrieve data from a website which gives prices of stocks.
It refreshes hourly. I then have some cells that make calculations based on the stock prices using a simple formula. I am trying to make it so that every time the data refreshes,
it recalculates based on the updated data, and that gets put into a new row.
Here is a picture showing what I need. https://imgur.com/a/qvYZ8wt
So for example, after running it for 12 hours, I want it to have 12 rows showing the results of the calculations. (1 row per hour).
It refreshes hourly. I then have some cells that make calculations based on the stock prices using a simple formula. I am trying to make it so that every time the data refreshes,
Here is a picture showing what I need. https://imgur.com/a/qvYZ8wt
So for example, after running it for 12 hours, I want it to have 12 rows showing the results of the calculations. (1 row per hour).
