Hello Friends
Excel Version : 2010
Attached File name : <Intraday to EOD.xlsx>
I am try to convert the Intraday data to End of the data (EOD) data.
The attached excel file contains two tab's namely 1) date in text format & 2) date in date format. In first tab Date is in Text format and in next tab date is in Date format
Now in both formats i need to do the following in the yellow cells H3:L5.
1) Auto populate the next dates (or if possible all dates)
2) The First time open value for the given date,
3) The maximum value for the given date,
4) The minimum value for the given date,
5) The Last time Close value for the given date.
thanks in advance
thilag
Bookmarks