Tradetiger to Amibroker data export in offline mode

Dear Sirs,

Anybody have the aplication which export SharekhanTrade Tiger intrday data in .csv format to amibroker charts. please share any utility. MCX Copper data shown for data reference.

Thanks in advance,



Date Time InSec Qty Open High Low Close Scripcode RequestId
20120316 10:00:00 36059 121 434.1 434.15 433.8 433.85 205872
20120316 10:01:00 36119 158 433.85 433.85 433.25 433.65 205872
20120316 10:02:00 36179 139 433.65 433.65 433.45 433.45 205872
20120316 10:03:00 36239 120 433.55 433.55 433.35 433.4 205872
20120316 10:04:00 36299 123 433.45 433.55 433.35 433.35 205872
20120316 10:05:00 36359 141 433.4 433.45 433.3 433.4 205872
20120316 10:06:00 36419 83 433.4 433.5 433.35 433.45 205872
20120316 10:07:00 36479 106 433.5 433.7 433.5 433.7 205872
20120316 10:08:00 36539 85 433.65 433.75 433.6 433.6 205872
20120316 10:09:00 36599 116 433.6 433.7 433.5 433.65 205872
20120316 10:10:00 36659 76 433.65 433.8 433.6 433.75 205872
20120316 10:11:00 36719 121 433.75 433.85 433.7 433.85 205872
20120316 10:12:00 36779 82 433.85 433.9 433.75 433.8 205872
20120316 10:13:00 36839 89 433.85 433.9 433.75 433.85 205872
20120316 10:14:00 36899 98 433.85 433.9 433.8 433.85 205872
20120316 10:15:00 36959 99 433.85 433.85 433.75 433.75 205872
20120316 10:16:00 37019 42 433.75 433.8 433.7 433.7 205872
20120316 10:17:00 37079 55 433.7 433.85 433.7 433.85 205872
20120316 10:18:00 37139 66 433.8 433.85 433.75 433.85 205872
20120316 10:19:00 37199 52 433.85 433.85 433.75 433.75 205872
20120316 10:20:00 37259 34 433.75 433.8 433.7 433.75 205872
20120316 10:21:00 37319 50 433.75 433.8 433.7 433.75 205872
20120316 10:22:00 37379 25 433.7 433.8 433.7 433.75 205872

I don't know Automatic method. Here is Manual way: Open data in Excel file then save it in CSV Comma Delimited format: http://www.traderji.com/amibroker/6...ata-expired-futures-contracts.html#post663015

:hug: Thank you very much sir,

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" );

Hello,

I am having EOD datas in Excel file (updating manually EOD datas of Gold spot in USD value). I want to use amibroker for my analysis with EOD values.

Help is requested to convert or import last 5 years datas from excel file to Amibroker. After initial data feed, I can feed EOD values manually on daily basis.

Thanks & regards,
Keerthi

I think I can try to help you.
What are the columns of your data.
Just post about 15-20 days (or more) data (any period).
I will try first myself and if successful will tell you.

Hello Chadra1,

Thanks for your response. 6 columns are listed below with few days data for your trial.

Thanks & regards,
Keerthi

Date Time Open High Low Close
11/30/2011 16:00:00 1704.7 1750 1703.32 1742.25
11/30/2011 20:00:00 1742.45 1749.96 1739.45 1745.15
11/30/2011 23:59:00 1745.025 1749.48 1744.255 1749.34
12/01/2011 4:00:00 1748.75 1750.365 1745.315 1747.415
12/01/2011 8:00:00 1747.415 1748.34 1742.55 1744.05
12/01/2011 12:00:00 1743.75 1754.15 1740.6 1750.75
12/01/2011 16:00:00 1750.125 1750.35 1742.8 1744.125
12/01/2011 20:00:00 1744.05 1753.475 1733.575 1743.975
12/01/2011 23:59:00 1743.975 1745.75 1742.15 1745.38
12/02/2011 4:00:00 1744.95 1745.95 1738.085 1742.21
12/02/2011 8:00:00 1742.135 1746.685 1740.435 1743.435
12/02/2011 12:00:00 1743.385 1753.8 1741.85 1750.55
12/02/2011 16:00:00 1751 1762.55 1745 1749.35
12/02/2011 20:00:00 1749.8 1753.275 1741.425 1748.425
12/02/2011 23:59:00 1748.425 1748.975 1744.425 1746.65
12/05/2011 4:00:00 1747.45 1755.005 1744.205 1746.155
12/05/2011 8:00:00 1746.305 1749.505 1743.505 1744.91
12/05/2011 12:00:00 1744.885 1746.955 1740.83 1741.805
12/05/2011 16:00:00 1741.855 1746.945 1728.68 1745.945
12/05/2011 20:00:00 1745.445 1745.98 1719.93 1722.13
12/05/2011 23:59:00 1721.755 1725.175 1717.93 1722.03
12/06/2011 4:00:00 1722.83 1724.53 1717.88 1719.48
12/06/2011 8:00:00 1719.48 1720.63 1708.68 1714.88
12/06/2011 12:00:00 1714.98 1723.055 1712.93 1720.03
12/06/2011 16:00:00 1720.18 1721.43 1704.855 1707.63

Chandra

save the excel file in csv mode. then in ami go to import wizrd, pick the file, put the format as DMY/MDY/YMD (suitable date format which the excel file contains), time (in HH:mm:ss), Open, High, Low, Close and finish the job. it will be imported in ami

nothing special about it

sr

Hi Keerthi
It can be done.
Do as sr has suggested.
I hope you will do it.
Otherwise post here again.

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