+ Reply to Thread
Results 1 to 3 of 3

Fibonacci retracements

  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    1

    Fibonacci retracements

    hi ,
    Need help in calculating the price movements
    suppose there are 2 prices 1 and 4 , i want yo know the 23.6% 38.2% ,50 % 76.8%

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Fibonacci retracements

    An interesting topic..

    With your start point and end point listed in C1 & D1 and the retracement levels in A1 to A5, use in B1 and drag down

    =MAX($C$1:$D$1)-ABS($D$1-$C$1)*A1
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    02-11-2013
    Location
    Los Angeles
    MS-Off Ver
    365
    Posts
    35

    Re: Fibonacci retracements

    Hi, just read over your post with a formula for fib. retracement. The formula provided was for an uptrend and I have tried to find one for the downtrend as well??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1