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.
posted by Patang! at 3/16/2006 03:24:00 AM
6 Comments:
Dear Visitors,
This blog is really nice and informative. We are pleased to know this blog is really helping people. Its our pleasure to post informative content on this useful blog created by webmaster.
Today that is 20-June-08 Inflation data has broken the records of past 13 years. Today declared Inflation was 11.05% which is too high. From last one month market is in no trade zone. Everyone is feeling pain from market response.
Just watch
The Sensex has lost more than 27% since its January peak, and trading volumes are down 46%.
Investors has lost there 70% of portfolio .
But still we say there are many undervalued stocks which can be used for investment.
To name few
1. DIGJAM
2. SBI
Most of the stocks are trading near to there 52 weeks lows. There are many fundamentally strong scripts too that are trading at lower levels. One can buy and hold them.
Nifty is expected to correct bit more and after that we can say market will be bullish. As this correction was overdue reason being if we observe in past months speculated stocks whose fundamentals are zero has also shown tremendous upward rallies in the market and now again they are trading at there real values. But still investors are trapped in them and no one is sure those scripts will ever reach those highs or not.
Stock market is a ocean where there are many pearls ( here scripts) so one need to select the best one. We strongly recommend if you are not intraday trader but investor then do go through company fundamentals and then invest.
For any query feel free to contact us.
Regards
SHARETIPSINFO TEAM
+91 9891655316
+91 9899056796
+91 9891890425
Hi,
5 days of rally in Indian stock market recommendation and again a crash. One day gap up opening next day just mirror reflection of it (Gap down). All points gained by nifty whipping out. Investors was thinking that they should reenter in the market and can take long positions but just see what happened. These kind of movement are called traps. Still we are expecting more short covering to come in 2-3 days.
But do remember overall market mood is bearish throughout the year. So invest money but for short term not for medium to long term. You will get much better opportunities to do so at more lower levels.
Thanks
Regards
ShareTipsInfo Team
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 quite nice and informative , we had a pleasure to post a comment on this usefull blog created by the webmaster
Tomorrow i.e. 31st July'08 the day when the Inflation data will come.Inflation from the past successive weeks is keep on increasing,this has now become a major factor deciding the following days movement of Indian Stock Market.RBI and the government is taking steps to control it.Inflation has to be kept under control for the interest of the economy, Indian Stock Market is governed by lots of factors one including them is Inflation that has also to be kept in mind always
Sectors giving good return over period of time includes:
1.INFRASTRUCTURE
2.PHARMA
Have a Query ?
Feel free to contact us
Happy Trading
Regards
Team
KnowYourProfit
+91-9871142419
Dear Visitors,
Now we have seen that Nifty has already cracked down alot due to recession fear. Reality sector was the worst affected in this fall. Stocks like WWIL, Unitech etc has fallen quite drastically. Investors are loosing confidence in the market. Maximum stocks are trading atleast 30% down from there 52 week high in Indian stock market .
Now one can think of buying stocks for Long term.
Few best stocks to be picked are:-
1. Reliance
2. Suzlon
3. Sesagoa
4. LT
Just grab these stocks at every dip and stay invested for atleast 3 months and see the appreciation yourself.
For any doubt please feel free to ask us.
Thanks
Regards
www.ShareTipsInfo.com Team
Call at:-
+91-9891655316
+91-9899056796
+91-9891890425
On Yahoo Messenger: ShareTipsInfo or ShareTipsInfo_1
On Google Talk: ShareTipsInfo1
Mail at:-
contact@sharetipsinfo.com
sharetipsinfo@yahoo.com
sharetipsinfo_1@yahoo.com
sharetipsinfo@gmail.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
Post a Comment
<< Home