Recent content by ZigZag

Hi Glenn,Trendi and A Dashing Blade, As usual Glenn " Spot On " Reference stored points " A Dashing Blade" kindly came to the rescue with the formulae. Stored points are ignored. What a relief. I dont think I would have had the nerve to ask you for a revised formulae. I am grateful for all...

Hi Glenn, Trendie Sorry for not replying but have been away.Glenn you are a genius. Your second formulae came up trumps. The problem I was having was transposing earlier cells which contained their individual formulae into cell 6. I found the solution by copying the actual numbers without the...

Hi Glenn, It may help my understanding if you can state your formulae in a written fashion. E.G. IF the absolute of A5 is less than 1 and/or/then........ Thanks for your time ZigZag

Thanks Glenn, Will check it out. Have a good evening.

Glenn,Coda, Thank you for your kind replies. Struth..... I was memorized by your solution after picking myself from the floor. :rolleyes: I am almost there or more correctly your skill is almost there. Over the last few days ive adjusted your formulae but only in a trial and error fashion but...

Excel I.F. Fuctiom Hi Glenn, How kind of you to reply. You are right of course my plea was incomplete. Let me start again. I am trying to produce Renko charts(similar to point and figure charts) with a reversal of 20 points. Therefore nothing is added or subtracted to the yesterdays close...

Help Please. Using the I.F function I get the normal response of True or false The following is what I require. Cell 1 = 100 Cell 2 = 110 If Cell 2 > Cell 1 by 20 respond with number. In this example as Cell 2 is not greater than 20 I need 100 Ex 2 Cell 1 =100 Cell 2 =145 As cell 2 > cell 1 by...

Excel IF Function Help Please. Using the IF fuction I get the normal response true/False. But this what I need; E.G Cell1 = 100 Cell 2= 110 If cell 2 > than Cell 1 by 20 give actual number. In my example, as cell 2 is not greater by 20 the response I want would be 100. e.g 2 Cell 1 = 100...

Acd Hi Alirezamehdipor, Nice charts . Help please. What time intervals are the charts. How do you calculate; the opening range, The A up & A Down . THe C point. Hope you dont mind. ZigZag P.S. I trade the Euro/USD

David, Thank you for an interesting article. You have certainly given your concept considerable thought. Im trying to test your conclusions using excel. However clarification is needed. You mentioned your price oscilator is calculated between the price and the M.A. Normally it is calculated...

That may be better for me. Wokingham based. Regards

Perrington Im not sure if you understand the difference between an event(your example 50% being a winner) and the probability of an event. Your premise would be correct for the outcome of a coin toss- a random event. Would you consider a football match a 50-50 bet ? Would the probability be...

Soccer, Congratulations you are half way to your goal. It took me 2 years of frustration to ask myself the same question. Successful Investing, speculating or gambling (call it what you will) relies on cold unemotional confidence on ones METHOD when participating in any market. In the arena...

Thank you Matt. Its about the only article On I.T. Ive actually understood. Your strength is knowing your audience. More articles please. ZigZag

zzaxx99, Try " what drives financial markets" by Brian Kettell. Publisher : Financial Times - Prentice Hall. The author has worked for many of the major banks. He now tutors for the banks. One chapter is devoted to the direction of equities, bonds and currencies after the main economic...