Is it possible ?

[andrey_tech]

But how ?

 

[PitchBlack]

Quote from andrey_tech:

But how ?

I have a Tradestation, and i can make 2, 3 or any days charts.
I do this by taking the hourly charts and by specifying the period as 24, 48, 72 ..... periods. This gives automatically 1, 2, 3 or... days charts.

I don't know if this is possible with Metastock.

 

[andrey_tech]

There is no chance on Metastock. You said before, it can be done by Excel. Do you know how ?

Quote from spike500:

I have a Tradestation, and i can make 2, 3 or any days charts.
I do this by taking the hourly charts and by specifying the period as 24, 48, 72 ..... periods. This gives automatically 1, 2, 3 or... days charts.

I don't know if this is possible with Metastock.

 

[PitchBlack]

Quote from andrey_tech:

There is no chance on Metastock. You said before, it can be done by Excel. Do you know how ?

Yes,
if you post the data in an excel sheet here i will pick it up and place it back afterwards.
Be sure to explain clearly what has to be done.

 

[andrey_tech]

I attached AA daily data. Need 2,3 and 5 daily (weekly) data from it. But more importantly I need formula about excel in order to apply all other stocks.

Thanks,
Andrey

Quote from spike500:

Yes,
if you post the data in an excel sheet here i will pick it up and place it back afterwards.
Be sure to explain clearly what has to be done.

 

[EliteInterest]

this is a simple problem

let us say you place the data in columns A thru E, starting with row 1

you want to convert the 1 day data to 2 day, so enter the following:

in cell F1, you type =B1
in cell G1, you type =MAX(C1,C2)
in cell H1, you type =MIN(D1,D2)
in cell I1, you type =IF(E2=0,E1,E2)

so, B thru E represent the original OHLC, and F thru I represent the new OHLC for 2-day data.

you now simply copy cells F1 thru I1 to F3 thru I3, F5 thru I5, etc, etc.
_________________________

if you want to convert to 5-day:

F1 stays the same.
G1 would become =MAX(C1:C5)
H1 would become =MIN(D15)
I1 would be come =IF(E5>0,E5,IF(E4>0,E4,IF(E3>0,E3,IF(E2>0,E2,E1))))

and in this case you copy F1 thru I1 to F6 thru I6, F11 thru I11, etc.

hope this helps

ps if you have 0's in rows below the last row of data, the formula for the new Low (column H1) would have to change (as the MIN function in excel will ignore a blank cell in a MIN calculation but will of course return zero if there is a zero there). this is possibly relevant for the last calculated candle.

also, if you see a smiley above, it actually says (without the spaces):
= M I N ( D 1 : D 5 )

i hope this is right; try it and let us know.

edit: one issue with this method is if there is a closing price of zero; this would possibly create incorrect output data. a modification would be to test for null instead of zero. however, for your purposes this is an unlikely scenario as it is unlikely you are testing data that ever has a closing price of zero. if you wanted to be sure (manually), you could put a test in as follows:

in cell J1, type =if(e1=0,1,0)

then copy this down to j2, j3, etc., all the way to your last row of input data.

then sum up those columns. e.g. if you have 14 rows of data, you would place in cell j15:
=SUM(j1:j14)
and if J15 is 1, then you have a closing price of zero in your data set..

sorry for digressing. i am sure there are more elegant, thorough, or perhaps simpler solutions to this potential logic error.

 

[andrey_tech]

Thanks for your help. But G and I columns gave error. F and H is perfectly done. I don't know the exact reason about the error. If you can test my attached file, maybe you can see the same error. Or ?

Quote from EliteInterest:

this is a simple problem

let us say you place the data in columns A thru E, starting with row 1

you want to convert the 1 day data to 2 day, so enter the following:

in cell F1, you type =B1
in cell G1, you type =MAX(C1,C2)
in cell H1, you type =MIN(D1,D2)
in cell I1, you type =IF(E2=0,E1,E2)

so, B thru E represent the original OHLC, and F thru I represent the new OHLC for 2-day data.

you now simply copy cells F1 thru I1 to F3 thru I3, F5 thru I5, etc, etc.
_________________________

if you want to convert to 5-day:

F1 stays the same.
G1 would become =MAX(C1:C5)
H1 would become =MIN(D15)
I1 would be come =IF(E5>0,E5,IF(E4>0,E4,IF(E3>0,E3,IF(E2>0,E2,E1))))

and in this case you copy F1 thru I1 to F6 thru I6, F11 thru I11, etc.

hope this helps

ps if you have 0's in rows below the last row of data, the formula for the new Low (column H1) would have to change (as the MIN function in excel will ignore a blank cell in a MIN calculation but will of course return zero if there is a zero there). this is possibly relevant for the last calculated candle.

also, if you see a smiley above, it actually says (without the spaces):
= M I N ( D 1 : D 5 )

i hope this is right; try it and let us know.

edit: one issue with this method is if there is a closing price of zero; this would possibly create incorrect output data. a modification would be to test for null instead of zero.

 

[PitchBlack]

Quote from andrey_tech:

I attached AA daily data. Need 2,3 and 5 daily (weekly) data from it. But more importantly I need formula about excel in order to apply all other stocks.

Thanks,
Andrey

This should work. If any problems, let me know.
Check the data because i didnt' check it.
Works for 1008 days of data.

 

[EliteInterest]

Quote from andrey_tech:

Thanks for your help. But G and I columns gave error. F and H is perfectly done. I don't know the exact reason about the error. If you can test my attached file, maybe you can see the same error. Or ?

make sure your data for columns C and E are numbers and do not have any spaces or anything like that..

 

[andrey_tech]

Perfect. It works. How can I add also 8, 13 and 21 days ? I can
not see the formula which you created.

Thank you very much for the vital help.