Hi,
I have a live price feed for the Australian market in my excel sheet. I would like to record the opening price on the first trade price of each day for the particular stock.
Looking at the screen shot:
In the event that both the following conditions are met:

1. Cell A6 = Cell $B$1 &
2. Cell $B$4 > 0

A macro should run that copy pastes the value in Cell $B$3 into B6.

This should automatically repeat for each day going forward.

Any ideas for a code to achieve this in VBA?

Thanks
Erik