piyush sharda said... I have a query about tech table updation. it was the post in which ilango sir mentioned abt updation. when I open the file the only thing that comes to my mind is I have to key in hourly values and daily values at the end of each hour.
Sir has written-- ------------------------------------------------------------------------------------------ 1.Charts are set for 400 weeks, 400 days & 400 hours. Every week or a month, adjust the data manually . For eg: If you need to add 40 days/hours, copy only from 43rd row "b,c,d,e-columns cells" and copy up to the last day/hour & more 50 cells & paste them on the 3rd row. Now clear the formulas in the last 40 rows.(Do not delete in the "Data" sheets anything). Once you try to implement it, it just takes a minute of your week end time. ---------------------------------------------------------------------------------------------- Not very good at xl so not abl to understand it much.
How can we update it. Is it keying in hourly values. I feel it is different that .
Sorry friends it deviates from nifty but pls help……….
-------------------------------------------- if it cant be typed pls, anybody who helps,write ur no on the blog or mail me at piyush_sharda@rediffmail.com with convenient time to talk.
Ilnago dont project BEARISH mindset with your own comedy table, be with bulls all retailers big blast on cards heading 5150 in few mins. ilango taken long , but as usual advised others to shorts, this is how this 'FREE MESSIAH"S work .
Facing the same problem, I did a little modification and ended up developing a new excel ... this file takes up the latest data for plotting the charts automatically, though it looks a little different than sir's but has all the values sir uses.
Guys just ignore this so called Cyber Crime Team..SEBI.Seems he has some mental problem.
Mr Cyber Crime Team-Sebi for your info impersonating a govt official/team is a serious crime under the Indian Penal Code. So you better behave and go elsewhere otherwise.......
I have traced one of this kind of DOG BARKING friend with my uncle's help who is a CBI inspector in chennai..he used to spoil my friend's blog space and we caught him..
Since Mr.Ilango asking us to concentrate only on learning..i was not taking these comments seriously..
If needed i can trace this CYBER friend .. CYBER you wanna bet ?
hi all, this CYBER CRIME TEAM - SEBI is no one but a person with MMB id of 'patience'. he does not like any person who becomes famous in stock analysis. he creates all sort of duplicate mail ids & visit many blogs & attacks all popular blogs one by one.
@ piyush , Give some time please. Lots of details are there in previous posts. After market Hours I shall mention the dates. For sample I have reposted the previous post.
METHOD TO INCREASE THE CHART PERIOD:
There are two methods: (Presently the file has 400 rows of data in the chart). Choice-1: You can copy the data in columns A,B,C,D,E(date, open, high, low & close)from the 40th row to 450th row (to expand the data by 40)and paste the same from the 3 rd row. Do not copy the entire row but only the cells from 40th row a b c d e - columns. Once you have pasted, go to the end of the row which will be 363rd row and mask the entire rows from that row and click "Clear all contents" under the "Edit" bar.
This way, you can key in data for 40 more periods.
Choice-2: Right click on the graph and click on the source data, you will get under data range as below: =Data.H!$F$15:$F$400,Data.H!$H$15:$H$400,Data.H!$K$15:$L$400
Now change the number 400 to 440 or 450 or 500 to expand the graph. Change all the 400's to a new same number.
I hope this helps.
METHOD II Dare you need to right click the chart / near axis area. YOu need to change the minimum and maximum parameters.
e.g. for macd may be minimum setting is -20 ...change it to -60....
you may opt for search in excel...detailed procedure is given. just need to do thetrial ang error in a sample sheet. you will learn.
thanks
METHOD TO CHANGE CHART AREA
place cross hair at axis value area, right click,select format axis, select scale and change the values as you like.
78 comments:
This is my request on this blog..
"Be a respectable human being first.. then automatically you learn and earn.."
Example : Mr.Illango and Mr.Rajagopal..
Thanks..Anandan.R
reposting
piyush sharda said...
I have a query about tech table updation. it was the post in which ilango sir mentioned abt updation. when I open the file the only thing that comes to my mind is I have to key in hourly values and daily values at the end of each hour.
Sir has written--
------------------------------------------------------------------------------------------
1.Charts are set for 400 weeks, 400 days & 400 hours. Every week or a month, adjust the data manually . For eg: If you need to add 40 days/hours, copy only from 43rd row "b,c,d,e-columns cells" and copy up to the last day/hour & more 50 cells & paste them on the 3rd row. Now clear the formulas in the last 40 rows.(Do not delete in the "Data" sheets anything).
Once you try to implement it, it just takes a minute of your week end time.
----------------------------------------------------------------------------------------------
Not very good at xl so not abl to understand it much.
How can we update it. Is it keying in hourly values. I feel it is different that .
Sorry friends it deviates from nifty but pls help……….
--------------------------------------------
if it cant be typed pls, anybody who helps,write ur no on the blog or mail me at piyush_sharda@rediffmail.com with convenient time to talk.
but help reqd...........
illango sir;
in your nifty tech table file. there is a sheet for retracement. how to use it for EW projection. kindly guide us.
@prabha
I will try that
@arpitg
Yes i did all that
@navnnit
I will wait for your help EOD
Thanks all
Short HDFC in future..
Tradeing at top edge..( I am not sure why.. is it any positive news..? can it break next few day..
Anandan.R
Ilnago dont project BEARISH mindset with your own comedy table, be with bulls all retailers big blast on cards heading 5150 in few mins.
ilango taken long , but as usual advised others to shorts, this is how this 'FREE MESSIAH"S work .
hahah
same attack of piyush
at manunidhi21@gmail.com
Ilango sir,
Considering the wave started at 4840 and ended at 5147, 38% retracement comes to 5030. Am i right. Please correct me If I am wrong.
anuj,
one more thing....have got any brokey.dll file in amibroker directory...? please check it.
it must be there...
-arpit
CYBER CRIME TEAM -SEBI ---------- who are you man ......pl. dont come here for these things......you are requested not to spoil this place
regards
vikram
manu sirjee same attack means????
CYBER CRIME TEAM -SEBI
i request you the same
R.Cyber ... - exposing yourself ?
@ Vikram - Why regards for this fellow -
Hey Cyber crime,
Are you Swami Bangalore or Chanakya...something fishy...
So, u r not trading... only watching Ilango...?? Good learn something from him..
Did i saw Id as CYBERCRIME TEAM-SEBI.........hahaaaahhhhh
Get a life bro, try Vipassana
H&S in Nifty future break of yest. low Ilangos tgt of 5050 may come.till then trailing short done in morning.
Ilango
ur view?
very rite sujhatha,............ yesssss he may be swaaamiiii........the same parasite
vikram
@Piyush,
Facing the same problem, I did a little modification and ended up developing a new excel ... this file takes up the latest data for plotting the charts automatically, though it looks a little different than sir's but has all the values sir uses.
Inspiration goes to Sir ... :)
Rgds.
very true sujatha
Guys just ignore this so called Cyber Crime Team..SEBI.Seems he has some mental problem.
Mr Cyber Crime Team-Sebi for your info impersonating a govt official/team is a serious crime under the Indian Penal Code. So you better behave and go elsewhere otherwise.......
this cyber thingie is a person we know as swmi
trust me he is a moron ignore such ppl
hi CYBER CRIME TEAM - SEBI, get lost from this blog...
Cyber crime
It is only a technical forum . Long or short it is the indivudal deceision. Dont personalise any thing against Illango or any other person.
First of all , all should bury their EGO.
Try to help others
Bala
Brief bounce off the lows may be over near the "Hour high ema".
2.30 Broken trend maintained ?
Oops... so finally It's Swami again? No forum or blog not available to you... landed up here?
Please ignore the CYBER CRIME, if we reply to him he will do more.
Ayya, konjam neengale intha blog vittu poyidunga , punniyama pogum. Oru nalla manushna vittu vaingpa nattula.
Ilango sir,
Can you post the Hourly chart with the possible moves?
I have traced one of this kind of DOG BARKING friend with my uncle's help who is a CBI inspector in chennai..he used to spoil my friend's blog space and we caught him..
Since Mr.Ilango asking us to concentrate only on learning..i was not taking these comments seriously..
If needed i can trace this CYBER friend .. CYBER you wanna bet ?
Sorry if am diverting other fellow friends here..
Ilango
H&S in Nifty.
cyber commented harshly but nifty moving towards 5150
cyber don't spoil the atmosphere here,share knowledge like ilango
sujatha sollurathu right, punniyama pogum. :)
no help yet. sir, somebody, now 3 guys have same problem maybe many more.
@assortZ
Catch him and let me know where ever he is I will go and kick his ass.... SOB.
Ilango sir is not a masiah......... he is a good person with bigger heart.
piyush i know little about excel.i think i can solve your problem
just ping your id to
saravanan9291@yahoo.co.in
prosenjit,
COOl..let us concentrate on nifty's march towards 5079
let this man scratch his head how to protect himself from my tracking..
cheers
we have crossed 1 cr OI on 5k puts...5100 calls OI also increasing.78L now
hi all, this CYBER CRIME TEAM - SEBI is no one but a person with MMB id of 'patience'. he does not like any person who becomes famous in stock analysis. he creates all sort of duplicate mail ids & visit many blogs & attacks all popular blogs one by one.
Raj,
Make yourself comfort..Please read Mr.Ilango’s comment on the above post..he has mentioned that “after a brief bounce” that’s what happened now..
Breaching today’s low will take us to 5080…of course am not chasing price..
hello ilango
if close above 5114 can carry longs?
syamala
hello sorry
can carry short nifty
syamala
CYBER CRIME..... is now frozen on the down circuit. No takers.
@ piyush , Give some time please. Lots of details are there in previous posts. After market Hours I shall mention the dates. For sample I have reposted the previous post.
METHOD TO INCREASE THE CHART PERIOD:
There are two methods:
(Presently the file has 400 rows of data in the chart).
Choice-1: You can copy the data in columns A,B,C,D,E(date, open, high, low & close)from the 40th row to 450th row (to expand the data by 40)and paste the same from the 3 rd row. Do not copy the entire row but only the cells from 40th row a b c d e - columns.
Once you have pasted, go to the end of the row which will be 363rd row and mask the entire rows from that row and click "Clear all contents" under the "Edit" bar.
This way, you can key in data for 40 more periods.
Choice-2: Right click on the graph and click on the source data, you will get under data range as below:
=Data.H!$F$15:$F$400,Data.H!$H$15:$H$400,Data.H!$K$15:$L$400
Now change the number 400 to 440 or 450 or 500 to expand the graph. Change all the 400's to a new same number.
I hope this helps.
METHOD II
Dare you need to right click the chart / near axis area. YOu need to change the minimum and maximum parameters.
e.g. for macd may be minimum setting is -20 ...change it to -60....
you may opt for search in excel...detailed procedure is given. just need to do thetrial ang error in a sample sheet. you will learn.
thanks
METHOD TO CHANGE CHART AREA
place cross hair at axis value area, right click,select format axis, select scale and change the values as you like.
hello friends
ilango may be buusy any body guide me id close abov ehigh ema 5114 can carry short'
syamala
Piyush,
I will send you an email tonight with repect to Ilango Sir's excel. I hope I can clear your doubts.
Regards
HI Rajgopalji,
I am not able to access your file 4shared.
Please guide me.
Thanks,
Piyush Patel
Cyber crime team is a reality, please take him seriously by ignoring.
But a jokers are always there in the circus of life.
Thanks CCT-SEBI, ur parent organisation too is a Bunch of jokers.
regards
Radhika
Rajgopalji,
My email id: piyush_patel21@yahoo.co.in
Thanks & regards,
Piyush Patel
saravanan sir , mail bouncing frm ur id 'mailbox not found,
HI Aprit,
did you resolve that problem??
hi..Syamala,
If it closes above 5115, close your shorts.
respected all
the same Q of shymla ....i am also need to get the answer....but i m short in banknifty ...can i carry forward that for tommorow
please reply seniors and experts
regards
vikram
@Anuj... add me on yahoo msgngr...(navnit_t) will help now with ur Amibroker
Piyush - will be resolved EOD.
Piyush,
no...still pending...will see after market hours
-arpit
Piyush,
I think Satheesh has clearly explained how it is done. Is it clear to you now?
Looks like Reliance will break below the range 1003 - 1000 which will aid the shorts!!
piyush sharda
sorry add it as saravanan9291@yahoo.com
hello friends
any body can guess where is yhe average closing comes?
syamala
Ilango Masterji
Can i carry short5131 overnight ?
ssham
Ilango sir,
The 5MA line has crossed the 20MA line and is below it in hourly charts. Can you give the significance?
ilango
any guess about closing spot nifty below n5114 or above?
syamala
Nice day action in the Nifty today...
Buyers have showed their hand at 5100 in Nifty and 9060 in the BN for several days now.
These levels have to be taken out, for the sellers to be in business.These levels can also be used to build long day positions with tight stops.
@ Vikram,
Close your shorts today.
Viren sir, shall i carry my long taken at 5100 for tomorrow or book profit now at 5120?
sundar sir,
not very clear but i may get few things on 2nd reading.. if u have some other wroteup pls also send that on piyush_sharda@rediffmail.com
If you are in profit take it now.
rajgopal sir u were right again abt cyber.... hats off
All the weaknesses have been getting corrected in intra.
Nifty has still not touched the 5 ema once during this upmove. Till the price weakness materialises, only short term trading is possible.
It's turned out to be a neutral day with no clear advantage to buyers or sellers.
The close at the Developing POC shows the nature of the day.
Ref lines are clear 5145-5155 on the upside and 5090-5100 on the downside.We are in the middle..
bought telco @791.5 today, stop loss @775. got settled around 777 !!
AD ratio is in favour of bears..!!
viren sir, thanks. booked profit of 22 points at 5122.
carrying nifty short as planned stop lose as 5190
Beware of Ides of March!
Hi Paresh..
Yesterday also you loss on Telco time times in both side..??? today again..wrong side..?
is it you are getting my trend..
Nifty now put on every one on gassing game
If Dow fall 100 points then we have big downfall...
Anandan.R
Paresh-forget this counter for some time please.
Thanks big brother
i closed my short at 5115, with profit of Rs 1400.00
My day was made and i am happy with small profits.
regards
Radhika
Rajagopal ji
how is drunk Nifty these days, missing. Please do update on his drinking habits.
regards
Radhika
Post a Comment