Excel to MT4 (realtime data feed)

Have some interesting ideas about how to improve the software? Let us know in this section!
Post Reply
john_3b2
Posts: 9
Joined: Mon Jan 05, 2015 5:59 pm

Excel to MT4 (realtime data feed)

Post by john_3b2 »

Hi,

In India, most of the data vendors provide the data in Metastock/Amibroker format at reasonable price. Few of them providing the MT4 data at high price, which will not match our Indian trading terminal softwares. So using MT in Indian market is least.

The Trading Terminal software like TradeTiger, Omnesys Nest, Omnesys Now, Odien diet,..... having an option "Link to Excel" which will update the realtime data in Excel.

For Amibroker
With this option, Yusufi Bharmal had created Nest2Ami without using Excel he straightly fetch data from Nest Trading Terminal to Amibroker with backfill. It's a good software, which exactly match the trading terminal data.
http://91-33.com/download/Nest2Ami.html

For MT4
With the same concept Ramdas had created Excel to MT4. It's working, but sometime fails. I don't know why.
http://www.traderji.com/day-trading/847 ... ing-2.html
http://niftyfno.forums-free.com/metatra ... 0-t72.html

If Tickstory added this concept it will be nice, then in Indian Market people will start to use MT4.

Here i like to add some useful files related to this topic.

Thanks
John Samuel
Attachments
related files.rar
(3.99 MiB) Downloaded 2660 times

tickstory
Posts: 4883
Joined: Sun Jan 06, 2013 12:27 am

Re: Excel to MT4 (realtime data feed)

Post by tickstory »

Hi John,

Thanks for the information - this sounds like a great idea and we will look into it further. Do you have any further information that might assist us such as the links to the various software terminals? Is it specifically real-time information that people are after or do they need historical data as well? As far as languages go, are these software products all in English or would it be necessary to translate to Hindi?

Thanks.

john_3b2
Posts: 9
Joined: Mon Jan 05, 2015 5:59 pm

Re: Excel to MT4 (realtime data feed)

Post by john_3b2 »

Hi,

Thank you for considering my idea and expectation.

Fetching data from Trading Terminal
http://www.omnesysindia.com/ developed the software Now (to trade in NSE only) and Nest (to trade in NSE, BSE, MCX,....), and providing to Retail Brokers.
They also providing NestPlus plugin to get backfill for 20 days.

Brokers providing Nest
http://zerodha.com/ (http://zerodha.com/download/ZerodhaTrader_3.11.2.1.exe)
http://www.compositedge.com/ (http://www.compositedge.com/download/Ne ... itedge.exe)
http://sasonline.in/ (https://www.dropbox.com/sh/0ds6povdqqpc ... dnod2dN8Qa)
http://tradejini.com/index.php (http://tradejini.com/credential/phocado ... i_inet.exe)
and so many

Nowadays Brokers are trying to make their own software with the commercial source code providing by Modulus Financial Engineering
http://www.modulusfe.com/ (http://www.modulusfe.com/download/stcx5trial.exe)
Brokers using M4 Trading Platform are
http://zerodha.com/pi/
https://www.ilfsdp.com/
and few

Unfortunately in India, we can't create demo account. So to have an account and to access both software zerodha is correct.
http://zerodha.com is using both Nest and StockChartX

These two sofware having the options "Link to Excel".

Yusufi Bharmal created the software to fetch realtime data directly from Nest and Pi (source code from modulusfe.com) to Amibroker
http://91-33.com/download/Nest2Ami.html
http://91-33.com/download/Pi2Ami-SampleScreenshot.html


Fetching data from various Server
Please download from below link
http://www.marketcalls.in/wp-content/up ... racle2.zip

Please read, how to configure
http://www.samoasky.com/
http://www.marketcalls.in/softwares/wor ... racle.html
http://capitalmind.in/2014/03/beta-opti ... for-india/

select the PlugIn Server India (NSE) v1.8.3
Try with the symbol
for Nifty index = NIFTY
for State Bank of India = SBIN
for Infosys = INFY

This software using OOServerNSE.dll plugin to fetch realtime data for OPTION data from indian NSE server.

Please check can you use this pluging to get realtime data from indian NSE server.

Plugins for other server
PlugIn Server US (CBOE): http://www.samoasky.com/download/option ... rverUS.dll
PlugIn Server Israel (TA25, USDILS): http://www.samoasky.com/download/option ... elMaof.dll
PlugIn Server PHLX (Philadelphia): http://www.samoasky.com/download/option ... elphia.dll
PlugIn Server OMX (Nordic): http://www.samoasky.com/download/option ... rdicEx.dll
PlugIn Server OptionsOracle (DataCenter): http://www.samoasky.com/download/option ... Center.dll
PlugIn Server TradeZone Brazil (Bovespa): http://www.samoasky.com/download/option ... deZone.dll
PlugIn Server TD-Ameritrade: http://www.samoasky.com/download/option ... itrade.dll
PlugIn Server Canada (Montreal): http://www.samoasky.com/download/option ... ntreal.dll
PlugIn Server India (NSE): http://www.samoasky.com/download/option ... verNSE.dll
PlugIn Server Australia (ASX): http://www.samoasky.com/download/option ... verASX.dll


I got some more valuable information from internet, which i did't like to post here.
So, if tickstory provide their personal email id, i will sent it.

Thanks
John Samuel

john_3b2
Posts: 9
Joined: Mon Jan 05, 2015 5:59 pm

Re: Excel to MT4 (realtime data feed)

Post by john_3b2 »

Hi,

We can also get historical data in Nest.

In India the trading software which we are using is in English only. So no need for Translating to Hindi.

Thanks
John Samuel

tickstory
Posts: 4883
Joined: Sun Jan 06, 2013 12:27 am

Re: Excel to MT4 (realtime data feed)

Post by tickstory »

Hi John,

Many thanks for the comprehensive information. Given that it seems that it would take some time/effort to pursue this functionality, we'll need to gauge what sort of numbers of people would be interested in such a feature. From what I understand, data is only available to those with active trading accounts on each of these systems?

Thanks again.

john_3b2
Posts: 9
Joined: Mon Jan 05, 2015 5:59 pm

Re: Excel to MT4 (realtime data feed)

Post by john_3b2 »

Hi Tickstory,

Please see the below link and check is't useful to get the realtime data from Google

http://marketearnings.blogspot.in/2012/ ... anace.html

Thanks
John Samuel

tickstory
Posts: 4883
Joined: Sun Jan 06, 2013 12:27 am

Re: Excel to MT4 (realtime data feed)

Post by tickstory »

Hi John,

Thanks for the link. We have written some code for the Google import, however it probably wont get released until the next major update.

Glad to see you back online!

john_3b2
Posts: 9
Joined: Mon Jan 05, 2015 5:59 pm

Re: Excel to MT4 (realtime data feed)

Post by john_3b2 »

Hi Tickstory,

Thank you for your reply and the effort taken to develop the software.

Regards
John Samuel

vjvijay88
Posts: 1
Joined: Sun Apr 24, 2016 3:49 am

hi john ur mail id plz

Post by vjvijay88 »

Hi ,

I like your positing and i found that rt data found usefull,, i need RT data for amibroker india free my mail id vjvijay88@yahoo.com

Post Reply