How to get Live data (minute by minute) free in to AmiBroker

samueldaniel7

samueldaniel7

Manager - Equity Analytics

Posts : 128
Equity Stars : 5023
Reputation : 33
Join date : 2011-03-21

Guys,

Good news, it has been found that you can link DirectFN and Amibroker and you can get the live data free, tick by tick
so you can do all your charts / strategies on real time, you dont have to wait untill the market closes and manually update the EOD prices and do analysis (which we were doing all this time)
and more importantly its totaly FREE, you dont have to pay a single cent,
all you need to have is to get DirectFN from your broker and have it open and link it via DynData
i was exploring this idea after Metastock started the live data for 1620 USD per year, who wants to pay when its available free

Now this is the method,

Open Direct FN, Login,
Go to Watch List -> Colombo Stock Exchange -> Normal
Select all the stocks -> Right Click - > Edit -> Link to Excel with headers

Save the excel file,
Link it to Amibroker, there you go you have live data Tick by tick, keep the excel /DFN open all the time , it will refresh on its own,
today i tested it and it works

more over you can set alerts, alerts via email (alerts to mms so it will come to your phone)

cat

lokuayya

lokuayya

Senior Manager - Equity Analytics

Posts : 307
Equity Stars : 5102
Reputation : 18
Join date : 2011-07-06

Very Good find, now I am trying to do it,
By the way can you pls tell me how to export history eod data of all the stocks from Directfn to Csv file.
Is it possible to merge all the csv files in the history data folders of directfn in to a one file of amibroker format
.

lokuayya

lokuayya

Senior Manager - Equity Analytics

Posts : 307
Equity Stars : 5102
Reputation : 18
Join date : 2011-07-06

Hi samuel,
Pls tell me how to link the excel file to Amibroker.

maddu

maddu

Manager - Equity Analytics

Posts : 164
Equity Stars : 4998
Reputation : 34
Join date : 2011-05-29
Location : Location Base 1

Thanks budy...!!

samueldaniel7

samueldaniel7

Manager - Equity Analytics

Posts : 128
Equity Stars : 5023
Reputation : 33
Join date : 2011-03-21

ok i have saved the data here

gihanvithana

gihanvithana

Equity Analytic

Posts : 28
Equity Stars : 4722
Reputation : 0
Join date : 2011-08-02

Can BMS users use this .?Because BMS online trading is very slow although the internet connection is fast. Anything can be done?

kav4

kav4

Senior Manager - Equity Analytics

Posts : 369
Equity Stars : 5250
Reputation : 36
Join date : 2011-06-17

Save the excel file,
Link it to Amibroker, there you go you have live data Tick by tick, keep the excel /DFN open all the time , it will refresh on its own

How to link Excel to Amibroker?

samueldaniel7

samueldaniel7

Manager - Equity Analytics

Posts : 128
Equity Stars : 5023
Reputation : 33
Join date : 2011-03-21

ill post a detailed post by tomorrow on how to link excel

Trader

Trader

Stock Analytic

Posts : 13
Equity Stars : 4841
Reputation : 0
Join date : 2011-03-11

samueldaniel7 wrote:Guys,

Good news, it has been found that you can link DirectFN and Amibroker and you can get the live data free, tick by tick
so you can do all your charts / strategies on real time, you dont have to wait untill the market closes and manually update the EOD prices and do analysis (which we were doing all this time)

Thanks for the info.

DirectFN TWS displays real time stock prices and it auto-updates charts as well. (Correct me if I am wrong.) Therefore what is the advantage in linking it to Amibroker?
I must say That I am not familiar with Amibroker.

twimalasuriya

twimalasuriya

Senior Equity Analytic

Posts : 81
Equity Stars : 4822
Reputation : 6
Join date : 2011-06-28
Age : 47
Location : Colombo

samueldaniel7 wrote:Guys,

Good news, it has been found that you can link DirectFN and Amibroker and you can get the live data free, tick by tick

May I know know who your broker is ? Mine is acuity and they only have cdax.

amilaela

amilaela

Senior Manager - Equity Analytics

Posts : 430
Equity Stars : 5228
Reputation : 18
Join date : 2011-10-06
Location : colombo

yaa

hunter

hunter

Moderator

Posts : 786
Equity Stars : 6948
Reputation : 114
Join date : 2011-04-27

I like the idea!!

lasithah

lasithah

Stock Trader

Posts : 5
Equity Stars : 4851
Reputation : 0
Join date : 2011-02-11

How do you link the excel to Amibroker..

hannah

hannah

Stock Trader

Posts : 6
Equity Stars : 4652
Reputation : 0
Join date : 2011-09-07

samueldaniel7 wrote:ill post a detailed post by tomorrow on how to link excel

hi did u post this?

amilaela

amilaela

Senior Manager - Equity Analytics

Posts : 430
Equity Stars : 5228
Reputation : 18
Join date : 2011-10-06
Location : colombo

not understanding how to put live data tick.... where ??? ambi eke or excell??

ttissa

ttissa

Stock Analytic

Posts : 13
Equity Stars : 4688
Reputation : 0
Join date : 2011-08-01

Can anyone assist me in getting CSE Live Data in to AMIBROKER without using Direct Fn?

smallville

smallville

Associate Director - Equity Analytics

Posts : 4119
Equity Stars : 10117
Reputation : 530
Join date : 2011-02-03
Location : Back on Earth

ttissa wrote:Can anyone assist me in getting CSE Live Data in to AMIBROKER without using Direct Fn?

Not possible friend... U may have to pay a thumping amt like brokers..

ttissa

ttissa

Stock Analytic

Posts : 13
Equity Stars : 4688
Reputation : 0
Join date : 2011-08-01

Fine, I'll stick to getting via Direct Fn, once I know how?

Thanks

Sponsored content

Name*:
Phone number:
Email address*:
Comments*:
* - required fields	Learn

Name*:
Phone number:
Email address*:
Comments*:
* - required fields	Learn

Latest topics

How to get Live data (minute by minute) free in to AmiBroker

1 How to get Live data (minute by minute) free in to AmiBroker Sat Oct 15, 2011 1:36 am

samueldaniel7

2 Re: How to get Live data (minute by minute) free in to AmiBroker Sat Oct 15, 2011 6:45 am

lokuayya

3 Re: How to get Live data (minute by minute) free in to AmiBroker Sat Oct 15, 2011 6:51 am

lokuayya

4 Re: How to get Live data (minute by minute) free in to AmiBroker Sat Oct 15, 2011 7:57 am

maddu

5 Re: How to get Live data (minute by minute) free in to AmiBroker Sat Oct 15, 2011 3:19 pm

samueldaniel7

6 Re: How to get Live data (minute by minute) free in to AmiBroker Sat Oct 15, 2011 5:38 pm

gihanvithana

7 Re: How to get Live data (minute by minute) free in to AmiBroker Sat Oct 15, 2011 5:55 pm

kav4

8 Re: How to get Live data (minute by minute) free in to AmiBroker Sat Oct 15, 2011 8:57 pm

samueldaniel7

9 Re: How to get Live data (minute by minute) free in to AmiBroker Sun Oct 16, 2011 11:37 am

Trader

10 Re: How to get Live data (minute by minute) free in to AmiBroker Sun Oct 16, 2011 11:36 pm

twimalasuriya

11 Re: How to get Live data (minute by minute) free in to AmiBroker Mon Oct 17, 2011 7:46 am

amilaela

12 Re: How to get Live data (minute by minute) free in to AmiBroker Mon Oct 17, 2011 12:32 pm

hunter

13 Re: How to get Live data (minute by minute) free in to AmiBroker Fri Oct 21, 2011 5:03 am

lasithah

14 Re: How to get Live data (minute by minute) free in to AmiBroker Sat Oct 22, 2011 6:19 pm

hannah

15 Re: How to get Live data (minute by minute) free in to AmiBroker Tue Oct 25, 2011 1:23 pm

amilaela

16 Re: How to get Live data (minute by minute) free in to AmiBroker Mon Mar 19, 2012 5:27 am

ttissa

17 Re: How to get Live data (minute by minute) free in to AmiBroker Wed Mar 21, 2012 9:57 am

smallville

18 Re: How to get Live data (minute by minute) free in to AmiBroker Wed Mar 21, 2012 10:03 am

ttissa

19 Re: How to get Live data (minute by minute) free in to AmiBroker

Sponsored content

New topics