Realtime data NOW,ODIN,TradeTiger,Google,Yahoo > AmiBroker, Fcharts, Qtstalker

Status
Not open for further replies.

josh1

Well-Known Member

tempest

Well-Known Member
I am not appointed as salesman by any of them. I do not have any personal relationship with any of them. Zerodha is charging Rs.20 per executed order irrespective of no. of shares in that order.

Here is comparison -
Thanks Josh,

Its not a perfect comparison as IB charges only for first leg in Intraday and also Turnover charges much lower than zerodha. Also they sent me volume pricing which is lower than shown on website.

Anyway lets not discuss same here as detracts from thread. We can discuss same thru PM if need be.

@ All - Im not related in anyway to IB or zerodha except as user in latter. Suggest contact either party's sales office for exact details.
 

josh1

Well-Known Member
Thanks Josh,

Its not a perfect comparison as IB charges only for first leg in Intraday and also Turnover charges much lower than zerodha.
Yes! (For the sake of clarity only) I have taken Rs.40(20 x 2 ) as charges of Zerodha for two legs. I have not compared Turnover charges.

Agreed. Let us not divert from original objective of this thread.
 

josh1

Well-Known Member
Hi josh,

in NOW feed to MT4, Quotes comes from NOW to Excel through DDE Link.
Excel file VBA code generate one text file NOWTicker.txt Every one sec.
MT4 read NOWTicker.txt content quotes and update MT4 chart every 1 sec.
in whole process. from NOW to Price change on chart..time delay is atlest 2 sec.
Ref."http://niftyfno.forums-free.com/metatrader-4-realtime-chart-ticker-rt-gyn-v10-t72.html"

there is one excel file "TickerReaderNOW V10.xls" i posted in mention thread ...this excel file is very interesting.
When you click add name it automaticaly generate all NOW DDE Link's. so that you don't need to put it manualy,
in addition it also gives names to Quotes cells e.g "SBIN_lt". which is used to feed Realtime quotes to Amibroker.
"TickerReaderNOW V10.xls" can be used for NOW to MT4 as well as for Amibroker as it is.
You can view excel VBA codes..how i done it.

I have created another excel file which is not yet posted. but very interesting and usefull for amibroker. some clever ideas used it it.
in Amibroker feeding realtime quotes is very easy..and many uses that.
But for backfill people use different utility like stocklive or another.
it is possible to backfill 15day 1min data from google to Amibroker through excel with just one click. no need for any standalone software to do it.
One can directly backfill any stock or index data 1min 15day from google to Amibroker with excel itself.
I have not posted this excel file since need to arrange code in proper way.
if you want i can send you that excel file. so that you can add google backfill to Amibroker facility in excel tool you posted.
In this post i have highlighted important point's/tips which will help to imporve your current excel file
Missed this. I was travelling. Please do share your code. I shall use it for backfill. Autobackfill for cash scrips google will be useful be for many. In fact SR114 was requesting it sometime back. I guess it could be used to automate EOD data from NSE or Google also with a little tweaking.

I shall however stick to OLE Automation and ASCII import since DDE technology is obsolete due to some inherent limitations. I shall try to tweak your code to suit OLE.
 
Last edited:

josh1

Well-Known Member


Hi josh
Everything is working fine for me but body of candle is not showing for me.
You can see in attached image that full body is shown till i backfilled with data downloader but when I started data fetching from excel sheet, body is invisible.
I am using google data
Can you plz help me out ?
Shivangi

Regret late reply. This is happening because google has given the same time stamp for all the quotes generated during the entire minute. Amibroker overwrites the earlier quote if time stamp is same for the next one. You will see the last quote dancing on the chart instead of generating full bodied candle for one minute.

Which version are you using? Use latest RTG31.xlsm. Link is in my signature. If the problem persists let me know.
 

josh1

Well-Known Member
i mean i do all settings but
in now click to link to excel and
paste in excel then #N/A write on all column
now i what to do
thanks
Sorry for late reply. #N/A normally appears if NOW is closed so that Excel does not get any quote.

1. Are you using Excel 2007 or above? That is minimum requirement.

2. Other possibility is that you are using limited version of Excel.

If you are sure about your Excel, I will have to look into this on your machine. Send your Teamviewer details in PM. I shall look into it tomorrow before market begins.
 

prabhsingh

Well-Known Member
Hi Josh,

Is there any way to get real time Options data without using NOW?Are there any freely available real time feeds for options as well?
Why i dont have NOW is because of restricted environment at my Office.Just curious to know from where does NOW gets the data.Does it directly connects to NSE/BSE servers?
 
Sorry for late reply. #N/A normally appears if NOW is closed so that Excel does not get any quote.

1. Are you using Excel 2007 or above? That is minimum requirement.

2. Other possibility is that you are using limited version of Excel.

If you are sure about your Excel, I will have to look into this on your machine. Send your Teamviewer details in PM. I shall look into it tomorrow before market begins.

Mr Josh1

getting prob with backfill followed all steps as said in video but still not getting data into amibroker pls help. RT data working fine

thanks
 

a1b1trader

Well-Known Member
Hi Josh,

Is there any way to get real time Options data without using NOW?Are there any freely available real time feeds for options as well?
Why i dont have NOW is because of restricted environment at my Office.Just curious to know from where does NOW gets the data.Does it directly connects to NSE/BSE servers?
Yes, NOW gets its data from NSE. NOW is directly connected to NSE servers.
Or you have to subscribe to paid data for RT option data.
 

josh1

Well-Known Member
Mr Josh1

getting prob with backfill followed all steps as said in video but still not getting data into amibroker pls help. RT data working fine

thanks
Are you able to copy data from NEST to NOWBackfil.xlsm?
Check your Date setting. It should be dd/mm/yyyy.

Give a snapshot of C:\RT\NowBackfil.csv here.
 
Status
Not open for further replies.

Similar threads