1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures - Bac

[champ]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

dear
i am using google chrome and facing same problem
how to solve it
thanks

Even I am facing the same problem.
As google chrome is my default browser, neither the excel sheet is getting updated nor it is getting refreshed.

Please guide.

regards
Shashi

 

[hanumanthh]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Even I am facing the same problem today. My browser is firefox. VBA runtime error 13 and 9.
Thanks
Hanumanth Kumar

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Even I am facing the same problem.
As google chrome is my default browser, neither the excel sheet is getting updated nor it is getting refreshed.

Please guide.

regards
Shashi

My default browser is also Chrome... I am not facing any issues... I have not change any default settings..
What version of Chrome are you using...
I am using the latest version 20.0.1132. 57 m

As a work around you can set IE as the default browser...

Try Clearing your cache and see if it is working...

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Please also if the All the "References are pointing correctly".

From Excel 2007
1. Alt + F11 - You will be taken to the VBA code
2. Goto Tool->References

You should see the following References checked.
1. Visual Basic for Applications
2. Microsoft Excel 12.0 Object Library
3. OLE Automation
4. Microsoft Office 12.0 Object Library
5. Microsoft Forms 2.0 Object Library

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

See if the following links are giving you the right results

The Link to get the Intraday data for NIFTY charts
http://www.google.com/finance/getprices?q=NIFTY&x=NSE&i=1800&f=d,o,h,l,c,v&p=4d

Link to get the Index values from where we take the NIFTY OHLC
http://nseindia.com/marketinfo/indices/indexwatch.jsp

Link to get the NIFTY Futures Data
http://nseindia.com/content/fo/fomktwtch_FUTIDXNIFTY.htm

Link to get the Options Chain data
http://nseindia.com/content/fo/fomktwtch_OPTIDXNIFTY.htm

 

[pjadhav27]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Dear HealthRaj,

Do we have to manually copy the data from the links given or does the data is sourced directly from the web....Thanks/Pankaj

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Dear HealthRaj,

Do we have to manually copy the data from the links given or does the data is sourced directly from the web....Thanks/Pankaj

Some people were facing some problems in getting the latest data. So I have the link to see if they are getting the right data.

You don't have to do anything manually...

 

[run_run]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Sir how to Intraday trade as per your sheet ???

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Sir how to Intraday trade as per your sheet ???

Right now a Range is given for Intraday. So if market is trading within the range, then Buy at lower side of the Range and Sell at the Higher side of the range. If it is trading outside the range then that means it is Range breakout and so trade SHORT/LONG outside the range accordingly.

I will soon post another version of the tool, Where for Intraday, you can find the following

Sell At / Buy at, Stoploss, Target 1 and Target 2

For example for Intraday on Yesterday the Call would have been

Sell at @ 5112,
Stoploss @ 5127
Target 1 @ 5086
Target 2 @ 5061

 

[healthraj]

Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

For Today, the call would be Buy around 5145 NF, Stoploss @ NF 5125, Target 1 @ 5170, Target 2 @ 5195