Is it possible ?

A

andrey_tech

Is there any program for auto-convert daily metastock data into weekly, 2 daily and 3 daily data ?

Example:

Daily Open High Low Close

08/09/2005 13.4600 13.8500 13.3000 13.7400
08/10/2005 13.7700 13.8600 13.5500 13.6000
08/11/2005 13.5100 13.7000 13.3200 13.6200
08/12/2005 13.6800 13.7000 13.3600 13.6000
08/15/2005 13.3400 13.8000 13.1300 13.7900
08/16/2005 13.8000 14.4000 13.6100 13.7900
08/17/2005 13.6800 13.9300 13.3200 13.4300
08/18/2005 13.2100 13.5300 12.8200 13.1500
08/19/2005 13.1000 13.1000 12.3500 12.5700
08/22/2005 12.5000 12.9900 12.3200 12.7200
08/23/2005 12.7500 13.1400 12.7100 13.0100
08/24/2005 13.1100 13.4500 12.7800 13.1600
08/25/2005 13.2800 14.4300 13.2800 14.2000


NOW it must be

2 daily as

08/09/2005 13.46 13.86 13.30 13.60
08/11/2005 13.51 13.70 13.32 13.60
08/15/2005 13.34 14.40 13.13 13.79
......... etc
 
Quote from andrey_tech:

Is there any program for auto-convert daily metastock data into weekly, 2 daily and 3 daily data ?

Example:

Daily Open High Low Close

08/09/2005 13.4600 13.8500 13.3000 13.7400
08/10/2005 13.7700 13.8600 13.5500 13.6000
08/11/2005 13.5100 13.7000 13.3200 13.6200
08/12/2005 13.6800 13.7000 13.3600 13.6000
08/15/2005 13.3400 13.8000 13.1300 13.7900
08/16/2005 13.8000 14.4000 13.6100 13.7900
08/17/2005 13.6800 13.9300 13.3200 13.4300
08/18/2005 13.2100 13.5300 12.8200 13.1500
08/19/2005 13.1000 13.1000 12.3500 12.5700
08/22/2005 12.5000 12.9900 12.3200 12.7200
08/23/2005 12.7500 13.1400 12.7100 13.0100
08/24/2005 13.1100 13.4500 12.7800 13.1600
08/25/2005 13.2800 14.4300 13.2800 14.2000


NOW it must be

2 daily as

08/09/2005 13.46 13.86 13.30 13.60
08/11/2005 13.51 13.70 13.32 13.60
08/15/2005 13.34 14.40 13.13 13.79
......... etc
More...

Do it yourself with Excel. Very easy.
 
Converting daily data into 2 daily, 3 daily and weekly ?

A B C D E

8/1/2005 27.9 27.92 27.29 27.39
8/2/2005 27.36 27.93 27.39 27.4
8/3/2005 27.4 27.67 27.32 27.58
8/4/2005 27.54 27.57 26.92 27.11
8/5/2005 27 27 26.25 26.65
8/8/2005 26.7 26.79 26.1 26.27
8/9/2005 26.3 26.48 26.08 26.27

The above is the original excel file. The new excel file must be :

A B C D E

8/1/2005 27.9 27.93 27.29 27.4
8/3/2005 27.4 27.67 26.92 27.11
8/5/2005 27 27 26.1 26.27


A: Date
B: Opening price of the stock
C: Highest price on the date
D: Lowest price on the date
E: Closing price of the stock


The above example we turned daily price of stock into 2 daily. How can excel done by this automatically ?

Regards,
Andrey
 
It is about Gann analysis. Do you know how the raw daily data converted into many time frames 2,3, 5 or any selected time frames by using Excel or any other software ?


Quote from gnome:

You pique my curiosity.... what value would 2-day or 3-day serve over 5-day (weekly)?
More...
 
You must log in or register to reply here.
Back
Top