Morning Update at 0800hrs for Intraday Market Level

[pranayk]

hey pranay...

I did work on your excel but could not get much time to proceed further... I am sharing the partially done excel sheet so that someone can help here. I have a macro in it named

public sub gethistoricaldatadata(byval scrip as string, _
            byref yearhigh as double, byref yearlow as double, _
            byref halfyearhigh as double, byref halfyearlow as double, _
            byref quarterhigh as double, byref quarterlow as double, _
            byref monthhigh as double, byref monthlow as double, _
            byref fortnighthigh as double, byref fortnightlow as double, _
            byref weeklyhigh as double, byref weeklylow as double _
            )

and this is how you will use it to get the historical data

gethistoricaldatadata "tatasteel", _
            yearhigh , yearlow , _
            halfyearhigh , halfyearlow , _
            quarterhigh , quarterlow , _
            monthhigh , monthlow , _
            fortnighthigh , fortnightlow , _
            weeklyhigh , weeklylow

all these parameters passed are return variables and will hold the data in them... I am sharing this file so that someone else can help you here to code the rest of part while i will work on a "market research desk" tool that i recently started to work... A combination of quick tools that one might need in every day.. But dont expect any quick turnaround :d

have a good day.


www.vikasverma.com/downloads/tracking.zip

Dear Vikas
I am not able to understand the program. Can you please send me the excel sheet with all my requirements incorporated in it for one or two scrips

I want that my excel sheet should look like as attached excel sheet

Thanks
pranay

 

[pranayk]

markets for 18th nov 09

well the markets did exactly what was expected of it to do. With sluggish cues from asian markets, indian markets opened flat and the only thing it did was that it covered the gap of monday opening by falling till 5010.the moment the gap was covered and the low at 5010 was retested, there was no looking back for nifty which shot out like a tracer bullet vertically up towards mondays highs of 5073 & finally closed at 5062 again above the critical level of 5052.the movement of nifty on tuesday established the fact that every intraday correction should be bought into as the indices move towards the previous days lows.

The movement of nifty on tuesday has established a support around 5015 to 5025 on the intraday support line coming from the intraday lows of 10th nov, 12th nov & 17th nov. So on a breach of 5015 by nse index, one can ruthlessly short nifty future and can go on a shorting rampage in case 5010 is breached. In case this happens then one can safely reach the index level of 4975. Similarly on the higher side, a breach of 5074 can see sharp up move towards 5108 followed by 5120 towards 5152 with a small drinks halt around 5084 levels.

Abb, tata power, india cement, great off shore, biocon & ge shipping, these six stocks which were mentioned in our earlier news letter as highly operator and insider infected, should be gradually accumulated by medium to long term investors on every decline daily. However intraday traders should not trade the first 3 stocks & if at all they want to trade on abb, tata power & india cement, then they should first boldly short these insider infected stocks at the start or on any intraday rise and book profit before the end of the day because buying these stocks for intraday purpose has proved to be suicidal on many occasions

FOR INTRADAY TRADING ON WEDNESDAY, THERE IS EVERY POSSIBILITY OF CONTINUATION OF THE FLAT FORMATION THAT HAS STARTED ON MONDAY AFTER THE GAP UP OPENING TO THE HIGH OF 5073. HOWEVER WEDNESDAY BEING THE 3RD DAY OF THE CONSOLIDATION, A BREAK OUT OF THE FLAT TOWARDS UP SIDE IS MOST LIKELY. A DECISIVE BREACH OF 5073 CAN CONFIRM THE BREAK OUT THAT CAN SHOOT PAST 5100 LEVELS TOWARDS 5120 OR EVEN 5150. LIKE TUESDAY, TRADERS MAY BUY ON EVERY INTRADAY DECLINE WITH QUIT POINT BELOW 5010 INDEX LEVELS, WHERE ONE CAN BOLDLY SWITCH FROM LONG TO SHORT. INDEX HEAVY RELIANCE WILL AGAIN PLAY THE CRUCIAL ROLE FOR THE MOVEMENT OF THE INDICES.

 

[findvikas]

You are working so hard to help everyone... so I should contribute as much as I could.
Here is a better research desk for you... the daily data is still pending

http://vikasverma.com/downloads/research_desk.zip

Screenshot for others interested in this

few rules... for Index... the scrip name is NIFTY & SENSEX and better left as first two rows.

Scrip name should be less than or equal to 9 characters... in case of BHARTIARTL it should be BHARTIART suffixed with ".NS" or ".BO" for NSE & BSE exchange

I am taking care of everything automatically.. so you can enter BHARTIARTL and it will automatically convert it into BHARTIART.NS (assuming NSE is the default exchange)

Please send me comments if you face any problems...

 

[findvikas]

the weekly high/low are for past full week... and I am not counting the current week's data as its still in progress...

also I am expecting bugs to be there... so please evaluate and report and data mismatch

 

[pranayk]

CHART ANALYSIS

 

[pranayk]

morning update at 8 am 18 nov 09

dow rose from a low of 10362 to the high of 10438 and closed at 10437 a gain of 30 points. European markets which had closed when dow was trading -ve, closed in the red with uk ftse closing down by.6%.brazil continued with its upward march with another 1.2% gain. Asian markets although have opened strongly may give away the gains gradually just before opening of indian markets.

For indian markets, as there are no negative cues & since to day will be the 3rd day of consolidation after the gap up open on monday & as the gap was covered on tuesday, there is every possibility of a break out move on the up side perhaps after initial opening sluggishness. Traders may go long on a decisive cross over of 5075 index level for a move towards 5120 or higher levels. Similarly a fall below 5050 can be a good shorting point by risky traders for a quick gain which can be converted to a shorting rampage in case tuesdays low of 5010 is breached.

Long future position holders may continue to hold nifty futures but on any big rise, may write 5200 calls . Option buyers should be very cautious in carrying over of bought options in order to avoid seeing zero value of the bought options. Holders of lower calls may prefer to hold but should write higher calls to pocket the margin on the shorted higher calls by holding on to the lower calls.

 

[pranayk]

the weekly high/low are for past full week... and I am not counting the current week's data as its still in progress...

also I am expecting bugs to be there... so please evaluate and report and data mismatch

Dear Vikas

The high-low should be in same column. Presently it is in the same row
The annual data should be on the left and weekly data should be on the right.I am expecting daily data to the right of weekly data.
The date should be current


Pranay

 

[pranayk]

You are working so hard to help everyone... so I should contribute as much as I could.
Here is a better research desk for you... the daily data is still pending

http://vikasverma.com/downloads/research_desk.zip

Screenshot for others interested in this

few rules... for Index... the scrip name is NIFTY & SENSEX and better left as first two rows.

Scrip name should be less than or equal to 9 characters... in case of BHARTIARTL it should be BHARTIART suffixed with ".NS" or ".BO" for NSE & BSE exchange

I am taking care of everything automatically.. so you can enter BHARTIARTL and it will automatically convert it into BHARTIART.NS (assuming NSE is the default exchange)

Please send me comments if you face any problems...

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

 

[findvikas]

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)

 

[arbharath]

Dear Vikas,

Very useful sheet. But pl tell me how to use it for options of Nifty

Bharath