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

[sr114]

2. For this use the field "Symbol" instead of "Trading Symbol" in NSENOW and RTG31. That field is short. Currently you have removed it.

Josh

i normally use that field - Symbol instead of Trading Symbol. in fno for the future it creates a smooth roll over candidate otherwise every expiry i have to merge the present expiry with the past fno data to get the continuous data of the futures.

sr

 

[mrkanitkar]

Symbol field value is same for calls and puts all strikes it's NIFTY.

We have to rename symbols with short names.

 

[sr114]

Symbol field value is same for calls and puts all strikes it's NIFTY.

We have to rename symbols with short names.

MR

use the convention used in NSE-NOW-RT2.xls files (symbol+option+strike price) to get ur customised symbol naming

sr

 

[mrkanitkar]

MR

use the convention used in NSE-NOW-RT2.xls files (symbol+option+strike price) to get ur customised symbol naming

sr

Yes, I am not developer, so not sure how to put it in code.

 

[sr114]

Yes, I am not developer, so not sure how to put it in code.

MR

the format file (NOW.format) does the trick. fiddle there to get ur proper naming stuff.

NSE-NOW.format

# Format definition file generated automatically
# by AmiBroker's ASCII Import Wizard
$FORMAT Date_DMY, Ticker, Time, Close, Volume, Appendticker, Appendticker - look at this line
$SKIPLINES 1
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1

RTG3.format

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

u can set it up here (look at the bold lettered line)

sr

 

[josh1]

Yes, I am not developer, so not sure how to put it in code.

How many characters does MS allow? NIFTYCE5200 is 11 Characters NIFTY12JULFUT becomes NIFTY but TATAMOTORSCE140 is 15 characters. Does it take 15 Chars?

 

[aviator1123]

Dear Learned members ..
Please read this ..
StockBangladesh providing plug-in for Amibroker software, where user can enjoy live data feed for free. Ami Broker Data Plug-in provides real time data update directly into the Ami Broker software. Users can manage two different databases e.g. intraday (updated during trading time) and end of day .

Links to this is here
http://www.stockbangladesh.com/resources/amibrokerplugin

Can anyone here code something like this for Indian stock markets ?

Yeh dil Maange moree ...

 

[josh1]

MR

the format file (NOW.format) does the trick. fiddle there to get ur proper naming stuff.

sr

That will not work SR. He is importing live feed in Metastock. I will have to do some code changes to join the fields. However, the excercise may be futile if Metastock does not accept atleast 15 characters

 

[mrkanitkar]

I think limit is 14 character length for importing security. When imported NIFTY12JUL5100CE, it creates symbol as NIFTY12JUL5100.
When imported NIFTY12JUL5100PE, it creates symbol NIFTY12JUL5100.
If you have already imported NIFTY12JUL5100PE and then importing CE,
it create separate files with same symbol names using as2ms.
The moment you try to open it in MS, it says duplicate securities, and merges it to one file.
The symbol name NIFTY12JUL5100CE or NIFTY12JUL5100PE becomes NIFTY12JUL5100 after import.
-------------
I think we need to format all symbols ending with PE or CE as JUL5100CE or PE by removing first few characters.

 

[josh1]

I think we need to format all symbols ending with PE or CE as JUL5100CE or PE by removing first few characters.

That will not work. TATAMOTORS12JUL140CE will become 12JUL140CE. We cannot remove Scrip Name. Use the following fields instead in that order from column A to G

Symbol | Last Trade Time | Last Traded Price | Volume Traded Today | Open Interest | Option Type | Strike Price

Change this iine
CellValue = Cells(r, C).Value & ",I," & Format$(Date, "yyyymmdd") ' ' nge this (Insert comma and I after ticker name)

as below-
CellValue = Cells(r, C).Value & left(Cells(r, 6).Value, 1) & Cells(r, 7).Value & ",I," & Format$(Date, "yyyymmdd") ' ' (Insert first letter of Option Type, Strike Price, comma and I and Date after ticker name)

Change this line
C = 1

to
For C = 1 to 5

Change this line
C= C+1
to
Next C