The macro I give you assume you will open the worksheet everyday. If you skip days, you will miss out on information.Don't forget that. That macro can be run with a button on the page if you prefer, your choice.
Back to your question, if on the same row you have the price, let say column A, change this line on the macro.
"Cells(i, 4) = 50" to "Cells(i, 4) = Cells(i, 1)". The one "1" in the formula is the column you want to retrieve the information. one is column A, 4 is column D.
BTW, you're welcome, glad to help if I can