Tradetiger to Amibroker data export in offline mode

[sr114]

Hi sr
It is not for me, It is only to help Keerthi.
I am backfilling my daily data from Odin this way only.

its the proper way to dobackfill manually in ami from a csv file

sr

 

[keerthi405]

Hello sr114 & Chadra1,

Thanks for your support & help. Now I am able to load datas to ami to view charts.

Thanks again,
Keerthi

 

[rvg1953]

It's running excellently! Thank U!

 

[amitpandit4]

Pls help facing error in importing

Logging started for 'C:\Users\AMD\Desktop\IntraDayMXCRUDEOIL 19-Oct-2012.csv' file, using format definition file 'Formats\custom7.format'
Error in line Date,Time,Open,High,Low,Close,Quantity,Average
Invalid date format/value

 

[josh1]

Pls help facing error in importing

Logging started for 'C:\Users\AMD\Desktop\IntraDayMXCRUDEOIL 19-Oct-2012.csv' file, using format definition file 'Formats\custom7.format'
Error in line Date,Time,Open,High,Low,Close,Quantity,Average
Invalid date format/value

Date format in Custom7.format file and that in MXcrudeoil.csv are not matching. Amit, open both files in Notepad and adjust your date format in custom7.

 

[amit05101992]

yasu222,


Step 1 - Create file SKTODAY.format and copy it in format folder of Amibroker.Use following format

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Date_YMD, Time, Skip, Volume, Open, High, Low, Close, Skip, Skip, Skip, Skip
$SKIPLINES 0
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1


Step 2

1. U can directly import csv directly (no need to manipulate columns,date etc )
2. Double click scrip e.g sbin and open chart
3. Right click and save to default folder "C:\Sharekhan\TradeTigerNew\Chart\SBIN.CSV"

In notepad copy paste following code and save it as .js file.From command prompt run the above created file..It will import csv.

/*
** AmiBroker/Win32 scripting
**
** File: ImportQuotes.js
** Created:
** Purpose: Import quotes from a text file into a AmiBroker DataBase
** Language: JScript
*/

/* Create AmiBroker object */
AB = new ActiveXObject("Broker.Application");

AB.Visible = true;
var i=0;


AB.Import( 0, "C:\\Sharekhan\\TradeTigerNew\\Chart\\SBIN.CSV", "SKTODAY.format" );
AB.Import( 0, "C:\\Sharekhan\\TradeTigerNew\\Chart\\WIPRO.CSV", "SKTODAY.format" );
AB.Import( 0, "C:\\Sharekhan\\TradeTigerNew\\Chart\\TCS.CSV", "SKTODAY.format" );

AB.RefreshAll();
AB.SaveDataBase();

WScript.Echo("Importing from Sharekhan to TDB finished" );

sir pls help me
how to create sktoday.format file i dont no pls guide me.

 

[amit05101992]

yasu222,


step 1 - create file sktoday.format and copy it in format folder of amibroker.use following format

# format definition file generated automatically
# by amibroker's ascii import wizard
$format date_ymd, time, skip, volume, open, high, low, close, skip, skip, skip, skip
$skiplines 0
$separator ,
$cont 1
$group 255
$autoadd 1
$debug 1


step 2

1. u can directly import csv directly (no need to manipulate columns,date etc )
2. double click scrip e.g sbin and open chart
3. right click and save to default folder "c:\sharekhan\tradetigernew\chart\sbin.csv"

in notepad copy paste following code and save it as .js file.from command prompt run the above created file..it will import csv.

/*
** amibroker/win32 scripting
**
** file: Importquotes.js
** created:
** purpose: Import quotes from a text file into a amibroker database
** language: Jscript
*/

/* create amibroker object */
ab = new activexobject("broker.application");

ab.visible = true;
var i=0;


ab.import( 0, "c:\\sharekhan\\tradetigernew\\chart\\sbin.csv", "sktoday.format" );
ab.import( 0, "c:\\sharekhan\\tradetigernew\\chart\\wipro.csv", "sktoday.format" );
ab.import( 0, "c:\\sharekhan\\tradetigernew\\chart\\tcs.csv", "sktoday.format" );

ab.refreshall();
ab.savedatabase();

wscript.echo("importing from sharekhan to tdb finished" );

sir where to save the step 2 note pad file (means in which folder)
thanks in advance