Auto :- Using my program.
or
no any programe neded do if Manualy :- Get row data from here.
http://nseindia.com/content/equities/eq_fiidii_archives.htm
If you want data for some days, prepair excel file.
Put value like this
A1=Category, B1= Date, C1=Buy Value,D1= sell Value, E1=Net Value
Copy data for FII from NSE page and paste if in cell A2
Sort data, date should be in asanding order.
F1= Previouse index value
F2= =ROUND(F1+(E2/10),3), Copy this formula and paste it up to last row.
J1= <TICKER>,<DTYYYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>
J2= =A2&","&TEXT(B2,"yyyymmdd")&","&F2&","&F2&","&F2&","&F2&","&IF(C2>D2,C2,D2), Copy this formula and paste it up to last row.
Copy data fron J1 to last, Open a blank notepad, paste it. Save notepad and
feed it to TA.
dont forget any day , dont repeat any day.
For daily update use simple calculator and directly add into AB or metastok downloader.
Index= ohlc = previous + (net/10)
Vol= Buy or Sell (whatever is bigger)
or
no any programe neded do if Manualy :- Get row data from here.
http://nseindia.com/content/equities/eq_fiidii_archives.htm
If you want data for some days, prepair excel file.
Put value like this
A1=Category, B1= Date, C1=Buy Value,D1= sell Value, E1=Net Value
Copy data for FII from NSE page and paste if in cell A2
Sort data, date should be in asanding order.
F1= Previouse index value
F2= =ROUND(F1+(E2/10),3), Copy this formula and paste it up to last row.
J1= <TICKER>,<DTYYYYMMDD>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>
J2= =A2&","&TEXT(B2,"yyyymmdd")&","&F2&","&F2&","&F2&","&F2&","&IF(C2>D2,C2,D2), Copy this formula and paste it up to last row.
Copy data fron J1 to last, Open a blank notepad, paste it. Save notepad and
feed it to TA.
dont forget any day , dont repeat any day.
For daily update use simple calculator and directly add into AB or metastok downloader.
Index= ohlc = previous + (net/10)
Vol= Buy or Sell (whatever is bigger)