RTNOW excel to amibroker: Trading symbols changed in odd way
Dear Sir, First I must say my heartfelt THANKS to Josh for such a selfless service he has been doing here with his great talent, sweet humour and infinite patience to help the small traders like us. He deserves all the praise and thankfulness from our side. He has not only helped us getting the real time data and thus helped us save a few thousands (which is normally charged by data provides to give data from nse equity and future and mcx etc) but also has give us the power to be self reliant in data matter. It hardly needs to be mentioned that how immensely important it is for a trader to get the proper data (real time data in particular).
Initially I had faced a lot of problem in using this cute softy: RTG utility (RTNOW in its present avatar). But after watching videos and detailed instructions and helpful inputs by some other traders too, I was able to use that flawlessly without any problem, getting real time data from NOW to amibroker. But there was a problem of merging each symbol from say: BHEL-Eq to BHEl, which I had as I have been maintaining my database for many years with that great software Data Downloader.
Today I came across this RTNOW thread and downloaded these files and set my database anew. Of course it helped me get the Volume data. That is a great boon.
But I am facing a very strange problem.. when I pasted the selected (link to excel from NOW) scrips in the RTD sheet of RTNOW.xlsm, it did copied the files automatically to NOW sheet but somehow changed the scrips's Trading symbol in odd way. Some scrips like Petronet-EQ, YESBANK-EQ, TATAPOWER-EQ, BHEL-EQ have remained as it is.. without change, while others like TATAMOTORS-EQ, JPASSOCIAT-EQ etc have changed with F1 suffix. (I have attached pics screenshots)
1. As I had read the discussion bewtween JOSH and Smarttrader, this change is happening to create similarity between existing Trading Symbols in excel and used symbols in amibroker. But programmatically it should have changed ALL the scrips' trading symbol, why this selective?
2. Isnt it better that for equity/cash Trading symbol should be changed just by removing EQ .. like from TATAMOTORS-EQ to just TATAMOTORS as this is the symbol used by DATADOWLOADER.
FOr Equity future, it should be changed to TATAMOTORS-1 instead of TATAMOTORS-F1.
If I want to make necessary changes to achieve this, where should I do it? I will feel obliged to get any help. Thanking you. Manu Adam.
Dear Sir, First I must say my heartfelt THANKS to Josh for such a selfless service he has been doing here with his great talent, sweet humour and infinite patience to help the small traders like us. He deserves all the praise and thankfulness from our side. He has not only helped us getting the real time data and thus helped us save a few thousands (which is normally charged by data provides to give data from nse equity and future and mcx etc) but also has give us the power to be self reliant in data matter. It hardly needs to be mentioned that how immensely important it is for a trader to get the proper data (real time data in particular).
Initially I had faced a lot of problem in using this cute softy: RTG utility (RTNOW in its present avatar). But after watching videos and detailed instructions and helpful inputs by some other traders too, I was able to use that flawlessly without any problem, getting real time data from NOW to amibroker. But there was a problem of merging each symbol from say: BHEL-Eq to BHEl, which I had as I have been maintaining my database for many years with that great software Data Downloader.
Today I came across this RTNOW thread and downloaded these files and set my database anew. Of course it helped me get the Volume data. That is a great boon.
But I am facing a very strange problem.. when I pasted the selected (link to excel from NOW) scrips in the RTD sheet of RTNOW.xlsm, it did copied the files automatically to NOW sheet but somehow changed the scrips's Trading symbol in odd way. Some scrips like Petronet-EQ, YESBANK-EQ, TATAPOWER-EQ, BHEL-EQ have remained as it is.. without change, while others like TATAMOTORS-EQ, JPASSOCIAT-EQ etc have changed with F1 suffix. (I have attached pics screenshots)
1. As I had read the discussion bewtween JOSH and Smarttrader, this change is happening to create similarity between existing Trading Symbols in excel and used symbols in amibroker. But programmatically it should have changed ALL the scrips' trading symbol, why this selective?
2. Isnt it better that for equity/cash Trading symbol should be changed just by removing EQ .. like from TATAMOTORS-EQ to just TATAMOTORS as this is the symbol used by DATADOWLOADER.
FOr Equity future, it should be changed to TATAMOTORS-1 instead of TATAMOTORS-F1.
If I want to make necessary changes to achieve this, where should I do it? I will feel obliged to get any help. Thanking you. Manu Adam.
