I don't have anything to show here because I have no idea how to do something like this. I want to take the spot price of silver and put it among a line chart to show the changing price. I have a website to pull data from. I know how to import dat from the web by the way, that's not the problem. Every tutorial I can find revolves around using the historical prices. These charts do not update. Essentially, I want to have a graph that starts with one data point, and every day another is added, with a line connecting the two points. In other words, I want it to look like a stock chart that updates automatically. I understand by doing this I might need two columns; one with the date, and one with the silver spot price. I want the cells at the bottom of these columns to automatically fill themselves in. If I was to use this Excel sheet for a year and three days, I would want 368 rows in each of these two columns. Lastly, I want to be able to program the graph itself to be capable of displaying "Last week", "Last Month", and "Last Year". I am fine with using historical data for this, but I don't want to rely on updating it every single day afterwards.
Bookmarks