Hi Experts,

I need to convert short duration data to long time duration.

I have 1 min data of particular stock with Open - high - low close & volume.

I need to convert this 1 min data to longer duration data. say I have in I8:I13 - 15 min - 30 min - 60 min - 1 Day - 1 week - 1 month respectively so if I run code it creates sheets of this names if sheet is not existed. if existed then add data to existing sheets - if same data (Same date data) already there then over past on that data. There is Day Start Time 9:15 AM & Day End Time is 15:30 PM.

On Button click "Update"

Step 1 Find sheet names range I8:I13 - not found create - Found Update data

Step 2 Calculation of Data - say we have convert 1 min data to 15 min then - from 1 min data very 1 min Open = open of 15 min

high = highest high of 15 min from 1 min data which we are counting.

Low = lowest low of 15 min from 1 min data which we are counting.

Close = last 1 min data Close (15th min)

Volume = total volume of all 15 min from where we are counting.

I have one link which create Tick data to 1 min data see if that is useful.

Data Convert To Larger Time Frame - VBA
Thanks

Data.xlsx
to do this we need to change the whole logic !!! I have fixed the highlighting of the range but for excluding everything not between 9:15 AM and 15:30 PM I prefer a new question !!

Sorry, you will see when the code is posted that it is a whole different approach. Here we jump by a certain number of rows that are the same all the time, (we introduced an exception for the last attempt if date in the block is different) however now with the time different it is a different ball game.

As will need to test now each line time which we are not doing and will need to loop by line and not by block so different logic.

Do not think that I am after points, I am after a solution. and what you simply posted here for 15, 30, 60, 1day, 1week, 1month seems for you so simple yet so not simple due to time intervals and unwanted portions.

gowflow

Data-Convert-V03.xlsm