Thursday, March 16, 2006
XML-RPC Excel client for the NSE
I spent the afternoon writing an XML-RPC server and client in Excel for accessing the National Stock Exchange's order books. This is great if you want to just get the current bid and offer prices for various options or futures contracts in a portfolio. The RPC server scrapes the NSE site for the info and returns it as XML. The simple getquote() function in Excel is responsible for sending the request and returning the answer.
The sample Excel sheet is at http://patang.org/projects/nse/XMLRPCOptionViewer.xls
You might have to add a reference to the comxmlrpc library in the macro code. The library is available at http://comxmlrpc.sourceforge.net/.
Right now the RPC server only returns the bid side quote. I'm working on making it return more comprehensive data. If you download and use the spreadsheet, please let me know.
Subscribe to:
Post Comments (Atom)
6 comments:
ShareInfoline.com is the leading website in India providing recommendations on Indian Shares, Stocks & Commodities.
It Provides all its calls by way of SMS and gives more than 80% accurcay in results.
You can also check the Past Performance in our website www.shareinfoline.com
This blog is nice and informative and a pleasure to take part in it.
These are the great trading days in Indian Share Markets which nice and huge volatility there in NIFTY.
Indian Share Market King www.puntercalls.com is offering real time trading with them.
You may visit the site www.puntercalls.com for more details.
www.puntercalls.com is an initiative from Punter Groups, India.
With Regards,
Team,
Puntercalls.com
This blog is nice and informative,good to know that the blog created by the webmaster is very helpfull to the visitors
RBI has cut Repo rate by 100 BPS to 6.5%, due to this we can see some rebound in the Indian Stock Market, as this is one of the factors which will also decide the movement of Nifty in coming days along with different other factors,our advice for intraday traders is to trade light
Any Query
Call us
+91-9871142419
+91-9212663485
KnowYourProfit
Yes, nice information.
TradersPlace.
www.TradersPlcae.in
TradersPlace
This blog is nice and informative,
its our pleasure to post a comment on this blog created by the webmaster
Now in the coming trading sessions i.e. in Feb'09 one can see important factors deciding the movement of the Indian Stock Market,one of the them is the results of the Various companies which had to be announced plays a key role in the movement in the Stocks.So this is suggested to trade with a Perfect Strategy to be followed for trading in the indian stock market
We welcomed your Queries at :
+91-9871142419
+91-9212663485
Mail your Queries at:
knowyourprofit@gmail.com
www.KnowYourProfit.com
Post a Comment