@poorna_chandar WORKING SINCE 2 DAYS SHOWS N.A.
MCX ? or NSE
Ooh you are asking about =now() time function in excel?
can you try below set to IST
yes, hh:MM:ss.000 (000 means milisecond), millisecond variation.
Are you checking in off market hours? or are you using 64 bit version of ms office?
pi link to excel requires 32 bit version of ms office
running PI & excel as administrative also checked not working
place a timer (google)… sometimes excel not refresh itself, this timer refresh the cells.
macros will refresh data but there must be any data
Open Cmd as administrator and run below commands
cd /d “%WINDIR%\Microsoft.NET\Framework\v4.0*”
regasm C:\Zerodha\Pi\ExcelDataStream.dll\
it will fix the issue
copy and paste the above mentioned dos command on my cmd, please see the screen shot, is it correct !!
(checking the timing)
above for him,
the above command is to register the exceldatastream which got unsuccessful as per screenshot.
you can try reinstalling ms excel once and check?
ok, revert you, ur mail id !!? (got msg from support about system time, answer is waste)
THANKS @AlgoGeek FOR YOUR INPUTS
same error for me
i also try https://support.zerodha.com/kb/faq.php?id=52
NOT WORKING !!
For your problem, select enable all, trust setting and macro setting, restart, it’ll cure. same happened to me also.
they gave:
Handy Tip: If it does not work, right click on ZT and on Excel and run both these programs as ‘Administrator.’ If it still doesn’t work, don’t hesitate to pick up the phone and call us.
?!!!
finally excel gets data !!
i copy ExcelDataStream.dll file from pi folder and paste in Microsoft office folder where excel being installed & Boom !!!
thanks @AlgoGeek and @poorna_chandar