vwap is volume weighted price.
volume that should be used is the actual traded qty on the counter.
So vwap is calculated from instruments - price and volume.
Nifty spot does not have volume.
The volume what you see there is not the actual volume traded on the counter.
The volume what you see...
I think we can ignore movements caused by such news like adding/removing the stock to index or TA related views. On long run only it's performance matters. My view on it's stock price in the other post is based only on how as a business it could do and being a psu how the management may...
IRFC- I read about this in detail a year back and it has pros and cons.
Worst-case - Max downside 30% and stock will sail at same levels for years with occasional surges.
Best-case- May go up to 80 to 100 levels in 3 years and turn as good dividend stock and follow the...
Yeah but as you guys are saying the api link data is sometimes not available or some issues like that.
Can you suggest any paid utility or something like where i can get the sum totals of OI and change in OI for Nifty/BN ( current week alone is also ok ) to my Excel sheet.
Yes you are right..
I need total oi numbers ( calls and puts ) at regular intervals to my excel/other database, preferably at best time interval supported but as you said there is risk of blocking ips... any suggestion here ?
Also I checked nse options page and noticed that it is also updating every 1 minute and numbers are changing. I guess some new updates. :)
But getting the total OI on calls or put or chng in OI ( totals) is easy from the nse page ..right ? or are you managing to get those...
Yes IB gives 1 sec interval data for price , but how about OI ?
I thought OI is released every 2 or 3 mts by NSE and so do all brokers.
I observed few terminals (from different brokers) and even their terminals update OI every 2 or 3 minutes (OfCourse I checked this is long back).
Free or paid anything...any idea on any paid utility ?
or please let me know if you have any one who can do this for fee and that's better because we can ask to design the excel as per our requirement.
and we can keep it specific to the need.
Let me know please.
Can anyone please suggest any Free/ Paid tools (excel/ applications) to get data fetched from NSE options page to Excel sheet.
What we actually need is live Open Interest data and change in OI data. I see the data every 15 or 30 mts to get a view.
As of now I download the sheet from the link...