NIFTY Options Trading by RAJ

[nikhilbhat-1990]

sir excel sheet not updating

 

[ocil]

When i open the excel file i am receiving below error. Can any one advice me how to fix.
I am using excel 2013.
"Compile error in hidden modules: modClean. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.

 

[Relish]

There is something missing in sheet51 in OAT by Profitmaker.. sheet 51 data is not correctly transferred to Main sheet.. I request look in this since it is password protected.. Thank's

 

[Profittaker]

Dear All,

I have Updated new file. kindly check this.

Sorry for the Late Reply. Last one week i was in out of station. So i Couldn't update.

Note : I have Mentioned how to change Symbol name and Expiry Date Details in ALL Stock OAT file (View 51th Row of Main Sheet) .

COURTYSEY : Mr.Healthraj.

HAPPY TRADING. :thumb:.


Thanks & Regards,
Profittrader

 

[amitrandive]

Dear All,

I have Updated new file. kindly check this.

Sorry for the Late Reply. Last one week i was in out of station. So i Couldn't update.

Note : I have Mentioned how to change Symbol name and Expiry Date Details in ALL Stock OAT file (View 51th Row of Main Sheet) .

COURTYSEY : Mr.Healthraj.

HAPPY TRADING. :thumb:.


Thanks & Regards,
Profittrader

Just to confirm , the auto update is off.
Need to press calculate on the lowermost tab to update right?

Also only main sheet updating , others are not.
Referring only to Nifty sheet , have not checked others.

 

[Profittaker]

Just to confirm , the auto update is off.
Need to press calculate on the lowermost tab to update right?

Also only main sheet updating , others are not.
Referring only to Nifty sheet , have not checked others.

Dear Amit,
All Files are working fine to me . Which file do you ask? if OAT for all Symbols file then click Start Refresh Button on Main Page (Row n Column A1).

 

[amitrandive]

Dear Amit,
All Files are working fine to me . Which file do you ask? if OAT for all Symbols file then click Start Refresh Button on Main Page (Row n Column A1).

NiftyOAT file

Check the screenshots
First main sheet ok.
Rest all others showing Aug 28 data

 

[Profittaker]

First sheet also not updating. check your screenshot.(Top of the main page there showing Underlying index nifty 8001.95 As on Aug28,2015 15:30:46) .

I think you didnt enable Macros. kindly close and open this excel and enable macros. or try to click Data Menu in excel and click Refresh All Button .

 

[amitrandive]

First sheet also not updating. check your screenshot.(Top of the main page there showing Underlying index nifty 8001.95 As on Aug28,2015 15:30:46) .

I think you didnt enable Macros. kindly close and open this excel and enable macros. or try to click Data Menu in excel and click Refresh All Button .

Yes, now seems fine.
Do we have to manually update ?

 

[Profittaker]

Yes, now seems fine.
Do we have to manually update ?

Every time if you open this excel file first will ask enable or disable option. If you should choose enable . After that every 3 minutes ones this file will update automatically.

(or)

Click Excel Left Top Corner menu ---> Select Excel Options --->Click Trust Center --->Trust Center Settings ---> Trusted Location ---> Click Add new Location ---> Browse and Select your Modified OAT file folder ---> Click Ok.

Now you won't enable Macros Everytime . Try this.