Hi,
I am using the Data Stock feature to receive the previous closing value for CAD/USD. As of now, the Data Stock feature does not record historical data.
I already have a macro to get the CAD/USD data stock feature to automatically refresh every time I open the excel sheet.
I want to create a sheet where every day, a new row is AUTOMATICALLY added with the previous closing date in column A, and the value that the CAD/USD stock is generating.
Basically I want it to AUTOMATICALLY add a new row with a new date and value every time the CAD/USD stock changes value.
Please let me know if this is possible.
I am using the Data Stock feature to receive the previous closing value for CAD/USD. As of now, the Data Stock feature does not record historical data.
I already have a macro to get the CAD/USD data stock feature to automatically refresh every time I open the excel sheet.
I want to create a sheet where every day, a new row is AUTOMATICALLY added with the previous closing date in column A, and the value that the CAD/USD stock is generating.
Basically I want it to AUTOMATICALLY add a new row with a new date and value every time the CAD/USD stock changes value.
Please let me know if this is possible.