1) In Target Sheet we are copying and pasting the data of all the companies Date wise
2) D,I,N all in yellow are dates for which the data is saved
3)the first is Symbol and its closing price and Total trade Qty Date wise.
4) We need Match the Close price of every symbol,If its increasing it has to be in green and if decreasing
it will be in red.
5)Need to calculate the percentage of change of the quantity in H,M like wise
That is compare the G and C col and generate values in H ,if its inc it will be in green and decreasing it will be red.
6)Symbol From A,E,J etc is not in the same row we need to match with the above mentioned data
2) D,I,N all in yellow are dates for which the data is saved
3)the first is Symbol and its closing price and Total trade Qty Date wise.
4) We need Match the Close price of every symbol,If its increasing it has to be in green and if decreasing
it will be in red.
5)Need to calculate the percentage of change of the quantity in H,M like wise
That is compare the G and C col and generate values in H ,if its inc it will be in green and decreasing it will be red.
6)Symbol From A,E,J etc is not in the same row we need to match with the above mentioned data