Forex Sailing Fibonacci Calculator Download


With all of the Forex Sailing lessons being taught, you need to make a lot of calculations. To make life easier for you, I’ve created a fibonacci calculator specifically for Forex Sailing.

The calculator below is meant to be used with the Forex Sailing (swing trading) video course, but will also be used for Forex Surfing (daytrading).

Here is a quick list of previous Forex Sailing videos:

Download the Forex Sailing Fibonacci Calculator

Option #1: If you use microsoft excel, download the Forex Sailing Fibonacci Calculator in Microsoft Excel Format. If you have any difficulty with the MS Excel version, please use the openoffice version below. I don’t use MS Excel because openoffice is free.

Option #2 (recommended): If you don’t have microsoft excel (good for you!):

i.) download & install open office (completely free software)

ii.) download the Forex Sailing Fibonacci Calculator in Open Office format.

Screenshot fo the Forex Sailing fibonacci calculator

(click image to enlarge)

How to Use the Forex Sailing Fibonacci Calculator

It’s pretty simple. There are two sheets in the spreadsheet file.

  • The first sheet is called “Upswing” and has 2 pictures:
    • A 2-wave fibonacci pattern for trading the second wave
    • A 3-wave fibonacci pattern for trading the third wave

For Uptrending Trades, fill in the numbers in the green boxes, and it automatically tells you your buy, stop & limit prices.

  1. The first sheet is called “Downswing” and has 2 pictures:
    • A 2-wave fibonacci pattern for trading the second wave
    • A 3-wave fibonacci pattern for trading the third wave

For Downtrending Trades, fill in the numbers in the red boxes, and it automatically tells you your sell, stop & limit prices.

Using the calculators should be pretty self-explanatory. If you haven’t used a spreadsheet program before, you may want to wait until the next Forex Sailing video (#4), where I’ll show you examples of how to find Forex Sailing trades. I’ll be using the calculator in the video, so you should be able to use it easily after watching that video :)

The Calculator Also teaches you Forex Sailing

A cool feature of the calculator spreadsheets above are that they actually help you learn Forex Sailing. When you enter the prices you know, it gives you the projection on a picture of your trade! It uses the same picture that is used in the Forex Sailing videos (see below):

  • Share/Bookmark

Related posts:

  1. Forex Sailing Video #4 – Online Forex Trading Course
  2. Forex Sailing Video #6 – Online Forex Trading Course
  3. Forex Sailing Review and Reader Feedback
  4. Forex Sailing Video #5 – Online Forex Trading Course
  5. Forex Sailing Video #2 – Online Forex Trading Course

Tags: , , , ,   Posted in Forex Sailing

36 Responses to “Forex Sailing Fibonacci Calculator Download”

  1. RegitNo Gravatar Says:

    @Brian–The spreadsheet with the waves marked is a nice enhancement to what would otherwise be a typical, boring spreadsheet. I’m sure it will be a good visual aid to remind the user where each point on the wave is.

    Just a minor enhancement note. “To see dark, there must be light; to see light, there must be dark.” When creating a cell with a dark background, it is nearly impossible to read the text when it is also dark. For example, the black text is nearly impossible to read on the dark blue background.

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Regit – Thanks. I thought I used white text on the dark blue background…

    [Reply]

  2. nikNo Gravatar Says:

    pretty useful…
    but why are you concerned about ms excel not being free?? earning big fx money shouldn’t be a problem paying for it…..

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Nik – why pay when you can have it free? Linux is a superior OS to Microsoft, & it’s free!

    [Reply]

  3. Allan JNo Gravatar Says:

    thank you for that ,looking forward to understanding it than making use of it , your efforts are much appreciated and I for one am very grateful

    [Reply]

  4. EddieNo Gravatar Says:

    Thank you for this great visual tool. However, now I’m confused. when I’m using your calculator, the calculated target for point III is a point of 38% retracement of point 1&2. It is not retracing back from point II to 61.8% but it’s only retracing 38.2%.

    I hope you understood my question, please let m eknow and thanks for all your help.

    Cheers,

    Eddie.

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Eddie – watch video #2, it explains what you’re asking. It’s simply a matter of semantics. Here’s an analogy:

    Let’s say you walk 10 steps forward. You could walk back to step #6, OR you could walk 4 steps backward. Either way you’re in the same place.

    In the same way, Let’s say you move 100% forward. You could go back to 61.8%, OR you go 38.2% backward. Either way you’re in the same place.

    I hope this makes it clearer, it’s 2 ways of saying the same thing…

    [Reply]

  5. PatrickNo Gravatar Says:

    Thanks, Brian.

    I created an Excel spreadsheet to do this, too, but yours is way cooler better-looking :) . I especially like the go-signal feature!

    It’s a great tool.

    Many thanks!

    [Reply]

  6. EddieNo Gravatar Says:

    Thanks for the answer Brian but I still don’t understand after watching again video 2. LEt me give you an example and you let me know what you think. Please look at daily chart of USD/JPY.

    an uptrend that strted around March this year was broken towards the end of April.

    My points are as follows:

    Point 1: 93.65
    Point 2: 88.95

    Now is the problem: I calculated 61.8% retracement for point 3 and it came to about 91.7 while when I use the calculator it uses the 38% retracement of point 1 & 2 and the point it provides as point 3 is: 90.7.

    This is were I am confused and the numbers obviously are not the same. If I use the 61.8% retracement it’s less risk since the position will be closer to the stop loss (point 1: 93.65) but the price might not get there and stop at the 38% retracement and resume it’s downtrend from there.

    Sorry to bother you with this but I know this is valuable information that you are giving here and I want to be certain that I’m getting it.

    Thanks in advance for all your help.

    Regards,

    Eddie.

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Eddie – Ok, let me elaborate…

    If you have (going short):
    Point 1 (high): 93.65
    Point 2 (low): 88.95

    The calculator projects the 61.8% level as 86.05.

    Let’s look at the Profit/Loss ratio, using forex sailing:
    Profit target would be 4.7
    Max Risk would be: 2.9
    P/L = 4.7/2.9 = 1.62 = 162% = good!

    Now you want to retrace further. If you took it to the 90.7 (the 38.2% level), you would have a better P/L ratio of 4.7/1.8 = 2.61 = 261%. You could trade this. The problem with it is that there are a higher probability of trades that will fail. Plenty of people trade this level, but it’s not going to succeed as often. Think about it for a minute… Every trade that’s going really bad will pass through this level on it’s way to reversing the trend. I recommend the 61.8% level because you’ll have a greater success rate and it’ll build your confidence. Once you use good money management, you can experiment with these levels.

    Tip: any P/L > 100% is a potentially good trade. Look at these numbers:
    If P/L = 100%; you need to be successful MORE than 50% of the time to be profitable.
    If P/L = 150%; you need to be successful MORE than 40% of the time to be profitable.
    IF P/L = 161.8%; you need to be successful MORE than 38.2% of the time to be profitable.
    If P/L = 200%; you need to be successful MORE than 33.3% of the time to be profitable.
    If P/L = 300%; you need to be successful MORE than 25% of the time to be profitable.

    We’re dealing with probablities & profitability. It’s a complicated topic that all comes together at a magic point known as the 61.8% level. This is where probability & profitability are at a maximum level.

    [Reply]

  7. PatrickNo Gravatar Says:

    I’ve been trying to get it to run on my other computer, which has OpenOffice, but it keeps popping up the Filter Selection window, and I haven’t found a filter that will open it. Anybody have any ideas?

    Thanks,

    Patrick

    [Reply]

  8. steveNo Gravatar Says:

    Hi Brian,
    Thank you for the spread sheet.
    Even though I thought I knew about the 38% & the 62% levels & how to use them, for some reason when ever I pick the direction & place a trade. You could gaurantee it would go the other way. So much so that I thought I should REVERSE TRADE. What ever direction I thought the trade would go, I should trade in the opposite direction. Looking back I would have made a fortune. Lucky for me I have only been using a DEMO account.
    Anyhow after getting your FREE calculator & playing wth it for a little while.last night I decided to get a new 50k demo account & start afresh & only trade when your calculator says GO. I have been using the 4hr & 1hr charts.
    I have stopped trading tonight at 7pm australian time about 24hrs since first starting. This includes sleeping & going to work for a while.
    I am so pleased to say my DEMO account is up $6,640.00.
    I think I am even starting to see the trades now even without the calculator!!!!
    I hope my trading has finally turned a corner.
    I’m looking forward to your BOOT CAMP now.

    THANKS AGAIN.
    Regards Steve

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Steve – THANKS FOR SHARING THIS!!! Keep me informed of your progress, we’re basically going to be sharing these types of experiences in the bootcamp. Forex Sailing is an awesome method of trading! During the bootcamp, we’ll also do some Forex Surfing & scalping :)

    [Reply]

  9. RichardNo Gravatar Says:

    What happened to the downswing download? Only the upswing is there. Great tool by the way. I took about fifty pips(EUR/USD) with help from your calculator and videos last night and today. I’m going in for more now!

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Richard – look at the tabs at the bottom of the spreadsheet. You’ll see one called “Upswing” and one called “Downswing.” They are on 2 different sheets of the spreadsheet file. It should be at the left of the bottom horizontal scroll bar.

    [Reply]

  10. RichardNo Gravatar Says:

    Yep there it is, I should have seen that, thanks!

    [Reply]

  11. KulvadeeNo Gravatar Says:

    I tried the calculator on different timeframe, 5min, 15 min, 1 hr and all worked if I entered when it said go sailing. Does this mean we can use the calculator in any timeframe?

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Kulvadee – it works for all time frames. It even works for stocks, futures, etc… I’ll probably change the message to just “Yes – GO” and “No-STOP”

    [Reply]

  12. RobNo Gravatar Says:

    Aloha Brian,

    Useful time saving tool and very aesthetically pleasing to boot.

    Thank you.

    All the best.

    Rob

    [Reply]

  13. KulvadeeNo Gravatar Says:

    If P/L > 300%, do you consider to enter the trade or it’s too good to be true. What is the maximum P/L % you recomemnd?

    [Reply]

    Rapid ForexNo Gravatar Reply:

    300% is high for sailing. Are there some extreme wicks that you’re using for your high/low? I don’t look at the P/L exclusively, I’d need to look at the rest of the trade. IF the P/L is > 300%, you have a VERY HIGH chance of getting stopped out. If you do the trade, don’t risk a full 5% of your account, you might want to keep that one at 2%.

    [Reply]

    KulvadeeNo Gravatar Reply:

    I read your reply to Eddie earlier that;

    Tip: any P/L > 100% is a potentially good trade. Look at these numbers:
    If P/L = 100%; you need to be successful MORE than 50% of the time to be profitable.
    If P/L = 150%; you need to be successful MORE than 40% of the time to be profitable.
    IF P/L = 161.8%; you need to be successful MORE than 38.2% of the time to be profitable.
    If P/L = 200%; you need to be successful MORE than 33.3% of the time to be profitable.
    If P/L = 300%; you need to be successful MORE than 25% of the time to be profitable.

    And I just would like to know what the maximum P/L you will consider. In general when I used the calculator, mostly when I entered at around 160% P/L and the trades went my way and I didn’t use the extreame wick. I am also conservative and use the high/low close to the trendline.

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Kulvadee – I wouldn’t rule out any trade just because it had a high P/L. I would be a little more cautious of a P/L > 300%. Keep in mind that the higher the P/L, the higher the probability of the trade failing. A P/L of 1,000% would be an amazing gain, but this would mean a 100 pip stop for a 1,000 pip gain. While it can & does happen, 9 times out of 10 this trade will fail. I know you want a rule to follow, but you don’t really need one.

    If it makes you feel better, here’s a rule: Don’t do a trade with a P/L >300% or < 125% without my permission :)

  14. WInstonNo Gravatar Says:

    Brian Iinstalled open office. I tried to download the calculator. A MESSAGE SAYS “API CALL EXITED ABNORMALLY”
    What’s happening here?
    Thanks!

    Winston

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Winston – I’ve never encountered this issue. Can you try uninstalling & reinstalling? What OS do you have (probably windows – the most unreliable OS out there).

    [Reply]

  15. Richard BNo Gravatar Says:

    I downloaded open office and then the fib calc but something went wrong. I can only see the bottom of the calc and cannot get up to the top of he spread sheet. What did I do wrong? Can you help? thanks

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Richard – try downloading it again. Make sure you’re saving it to your computer. I just updated the file. Weird things happen sometimes. It should be fine :)

    [Reply]

  16. Fred Riggins Jr.No Gravatar Says:

    Brian,
    The Fib. Calc. downloads as a ods file and open office won’t open it. Help!

    Thanks Fred

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Fred – .ods is the standard spreadsheet file format for open office. Are you sure you have the spreadheet program installed?

    [Reply]

  17. RodnyNo Gravatar Says:

    Hi Brian,
    I have some questions,
    Let’s say that we had entered a trade at the 61.8% level you’ve recommeded. Then, the price continued its retracement (bad for us) until it touch the 38.2% level, finally at this level it went in our desired direction.

    Our limit will still be our entry price + 100% of I-II? or it should be changed to the price where finally turned around (I think this is point III) + 100% of I-II?

    I said this because I’ve read that when prices retrace a lot (to more than the 38.2% level) is more probable that the price don’t go much further after breaking point II.

    Thanks in advance,
    Rodny.

    [Reply]

    Rapid ForexNo Gravatar Reply:

    Point IV is based on point III, so the limit would change based on the actual retracement that happened. It’s an adjustment that you’d make during the trade…

    [Reply]

  18. GIBERTNo Gravatar Says:

    hello

    yup great tools so easy too used you cannot go wrong again many thanks for your good work
    sincerely
    GILBERT

    [Reply]

  19. M.ELshazlyNo Gravatar Says:

    Hello Brian ,

    I am an egyption fan of you , don’t wonder you are the only one that I trust in forex world , I am eager to listen your course , it is amazing when you see all your informations works in a simple way by using ur sailing method .

    Thank you man

    [Reply]

  20. VENKATNo Gravatar Says:

    Hi Brian,

    Thanks for this wonderful method.

    I downloaded the Fibonacci calculator. The downswing calculator works great.

    But there seemed to be a typo in the upswing calculator (or I just don’t know how to use it). I gave the I, II and III prices and the III target tells me No – Skip Trade even though my III price is same as III target. Also if I change the value of the III price that is not reflecting in the right side Risk reward ratio box. It always tells that Risk reward ratio is as 161.81% even if I change the value in III price.

    Sorry If I miss something in this or I didn’t look it properly. Can you please look in the calculator and let us know.

    I highly regarded your teaching and I am already in the HR course. Forex sailing I thought to give a learning and I am amazed the way the Fibonacci method works!!!

    Thanks for bringing this to all of us.

    Regards,
    Venkat

    [Reply]

    Rapid ForexNo Gravatar Reply:

    @Venkat – Thank you for your comment. The reward/risk ratio is fixed in the fibonacci calculator. It will give a “no” signal if that ratio isn’t met. Try adding/subtracting a pip or a few from your III price. It’s designed to only give you a green light if the ratio will work. Sometimes it’s very close to the borderline.

    [Reply]

  21. efrenNo Gravatar Says:

    Thanks Brian for this important tools.

    [Reply]

Leave a Reply