Morning Update at 0800hrs for Intraday Market Level

[pranayk]

Originally Posted by pranayk
1)The high-low values should be in same column so that the width of page is reduced.Presently it is in the same row.
>> This will be little tricky as I do not know as of now how to merge & center two cols/rows programmatically, which will be required to do so.

2) The date is 16th nov. It should take the current date i.e. 17th nov
>> blame it on Yahoo servers... I am only the requester...

3) After updating it is taking time to get the values. Is it possible to update the data by continuos monitoring without manual updating?
>> since we are looking at Historical data and not Intraday data... so it does not make a good design to keep monitoring and getting the same data. just hit the button once or I could make it to update automatically on Open.

Cheers!!!

(it complains that message is tooo short)

Dear Vikas

No excuses
We will find a way to improve till the desired results are achieved. I think You can do it.
All the Best!

Pranay

 

[Raju]

Vikas,

Thanks for the excel sheet.

My observations-

1. Takes time to fill the data.
2. Data for yesterday is not shown (Data shown = yesterday -1 day)
3. Me too interested in Options data

 

[findvikas]

I will see if I can use other source for filling data.. I wont be able to help out the speed as it has to make 2 web query per scrip... that is total 104 web calls... (50 nifty scrips and 2 index)

you can delete the not required rows from bottom and only monitor the scrips you are interested in to workaround the speed issues.

What kind of Options data are you looking for? please ellaborate...

 

[findvikas]

Pranay... sorry to hijack your thread.. guys please come to my daily trading diary thread

 

[pranayk]

markets for 19th nov 09


again it was another day of flat traded market within the range of 5080 on the higher side and 5040 on the lower side. There were n number of occasions when nifty behaved as if it was about to break out of the congestion zone but every time the bulls were frustrated. Once it even breached the highs of 5075 but it turned out to be another well planed manipulation to trigger stop losses above 5075 to fall again. However sooner or later the break out will come but not during actual trading, as 9 out of 10 beak outs have come as a surprise or as a gap up opening or based on some planted news on index heavies. So one has to wait and see when the decisive break out of 5080 resistance level or break down from 5010 support level will come.

Since the whole market is highly manipulated & everyone is thinking that market may beak out on the up side, one may find to his greatest surprise that nifty instead of breaking out of 5080 zone actually falls & breaches 5010 to re enter the sub 4900 area & very interestingly the break down may come as a big surprise, perhaps when dow is +ve and asian markets are also positive. So one must keep his fingers crossed for such an eventuality when high standard of deception & surprise are the trading theme every day.

For intraday trading on thursday, the lows of wednesday around 5040 provides a support only to be breached to move towards 5010 levels. On the higher side area above 5080 continue to pose as a formidable resistance to invite ruthless shorting with tight & must quit points above 5090 levels. Similarly in case nifty falls below 5040, one can go on a shorting rampage till 5010 levels. And a fall below 5010 may see a bonanza for intraday shorters. However an up side breach of 5080 and sustaining above it may see nifty move towards 5120 to 5150 levels which perhaps may be a bit tough this week. As the expiry on 26th is just 5 trading days away, one should not expect any sort of big fire works till expiry and option buyers fond of holding bought options may be the worst sufferers due to the sluggishness of the markets till expiry that may see the bought option value gradually being reduced to zero value like slow poison.

For cash trading, intraday traders may continue to ruthlessly short india cement cash irrespective of whether the over all market is bullish or bearish. Just close your eyes and ruthlessly short india cement cash with tight stop loss around this weeks high of 105 to 106 levels and enjoy the operators/insiders action of taking it to sub 100 levels

 

[arbharath]

I will see if I can use other source for filling data.. I wont be able to help out the speed as it has to make 2 web query per scrip... that is total 104 web calls... (50 nifty scrips and 2 index)

you can delete the not required rows from bottom and only monitor the scrips you are interested in to workaround the speed issues.

What kind of Options data are you looking for? please ellaborate...

Iam looking for Nifty CE and PE data. Thanks in advance

 

[pranayk]

Pranay... sorry to hijack your thread.. guys please come to my daily trading diary thread

Dear Vikas

HIJACKING is allowed till it is for noble cause


Now come to the Business
Please see this picture

You will appreciate the colour grading. This is in respect to previous day price.



Now see my proposed table as below:

I have coloured some cell. But I expect that the cell to take colour by itself based on change from previous closing price.In addition to this, the cell should also display the price. The last cell for daily data should diplay current market price when the market is open and its colour should keep on changing based on price variation.

Experts are also invited to work on this

Thanks

Pranay

 

[lazytrader]

Dear Vikas

You have done a marvellous job.
Few observations are hereunder for consideration:
1)The high-low values should be in same column so that the width of page is reduced.Presently it is in the same row.
2) The date is 16th nov. It should take the current date i.e. 17th nov
3) After updating it is taking time to get the values. Is it possible to update the data by continuos monitoring without manual updating?


Pranay

I think it will help if you make the LTP only to be updated since other data is only updated once a day.

Do consider that the data we are getting is a free resource and bandwidth abuse should be avoided. Make sure you limit the refresh rate if you do make it automatic.

I hope everyone remembers: With great power comes great responsibility

Those who are looking for Nifty option chain in excel with auto-refresh can download it below. Straight from the horse's mouth (Data from NSE server :lol. I've set the update to every 5mins. Minimum interval is 2min. (The limit is from NSE, nothing can be done to make it real time). It is very basic cause I don't don't have a lot of time right now. If anyone has issues let me know but I don't visit the forum often so will take some time.

http://www.megaupload.com/?d=5N14HZ7O

P.S: Nothing comes free, if you abuse bandwidth then you won't get anything. Bandwidth is a precious resource but most don't realize it. When you don't need auto refresh disable it at file open. Don't worry it doesn't get saved. Next time you open the file it will continue to autorefesh.

Njoy :thumb:

 

[talisman]

I think it will help if you make the LTP only to be updated since other data is only updated once a day.

Do consider that the data we are getting is a free resource and bandwidth abuse should be avoided. Make sure you limit the refresh rate if you do make it automatic.

I hope everyone remembers: With great power comes great responsibility

Those who are looking for Nifty option chain in excel with auto-refresh can download it below. Straight from the horse's mouth (Data from NSE server :lol. I've set the update to every 5mins. Minimum interval is 2min. (The limit is from NSE, nothing can be done to make it real time). It is very basic cause I don't don't have a lot of time right now. If anyone has issues let me know but I don't visit the forum often so will take some time.

http://www.megaupload.com/?d=5N14HZ7O

P.S: Nothing comes free, if you abuse bandwidth then you won't get anything. Bandwidth is a precious resource but most don't realize it. When you don't need auto refresh disable it at file open. Don't worry it doesn't get saved. Next time you open the file it will continue to autorefesh.

Njoy :thumb:

Hi LT,

Seems like a very useful and interesting file but I am getting this message while I click the link-

"The file you are trying to access is temporarily unavailable"

and BTW,
the hidden gems thread is hugely valuable. Thanks for this wonderful work.

 

[pranayk]

morning update at 8 am 19 nov 09

last night dow recovered from a low of nearly 70 points to close flat around 11 points -ve. Like indian markets, it was the 3rd day of flat formation above 10400 levels & perhaps a big up side break out is waiting for dow. Brazil after so many days of up side corrected by 1.5%. European markets closed absolutely flat.

For indian markets one can expected another flat day within the range of 5020 to 5010 on the down side and 5080 to 5085 on the up side. Traders can trade on both side of the markets by shorting at the higher side of 5085 and buying around the lower side of 5020 with tight stop loss of 15 points either way. On thursday, there is every possibility of the markets to breakout on the higher side after initial fall to flush out weaker hands. If the upward break out does not come on thursday, then friday 20 nov 2009 is the ideal date for the break out.