[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: how to change volume in 1min. intraday data?



PureBytes Links

Trading Reference Links

Why don't you open the files in excel, sum the last 2 columns into a 
new total volume column, delete the up and down volume columns then 
import it? Is this historical data by each individual contract or is 
it 1 file that has been roll adjusted? 

james,

i`ve tryed with excel, but it`s to large file for excel


--- In amibroker@xxxxxxxxxxxxxxx, James <jamesmemphis@xxx> wrote:
>
> Why don't you open the files in excel, sum the last 2 columns into 
a new total volume column, delete the up and down volume columns then 
import it? Is this historical data by each individual contract or is 
it 1 file that has been roll adjusted? 
> 
> ----- Original Message ----
> From: gsmservplus <domantas.rudys@xxx>
> To: amibroker@xxxxxxxxxxxxxxx
> Sent: Friday, July 11, 2008 11:49:27 AM
> Subject: [amibroker] how to change volume in 1min. intraday data?
> 
> 
> hi,
> 
> i`ve got txt files with cme,cbot and nymex futures intraday 1 
minute 
> historical data. there are data in 
> <<date,time, open,high, low,close, up,down>> formats. "up" is up 
volume 
> and "down" is down volume. how can i uplode that data to amibroker 
> through import wizard? because if i set in define field column 7 
and 
> column 8 like VOLUME in chart it reads only last "down" volume.
> example : for @ES symbol 
> 2/13/08,1654, 1350.75,1363. 00,1344.25, 1649.50,55, 126
> up is 55, down is 126, so, when i uplode to AB that data volume 
> indicator reads 126. i would like to get 55+126= 181(total volume 
for 
> that minute). how can i do it? or only way i`ve got to change all 
data 
> in those files manually?
> 
> thanks
>



------------------------------------

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/