+ Reply to Thread
Results 1 to 10 of 10

How do I add the Hull ma to this Book?

  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    orlando,Florida
    MS-Off Ver
    Excel 2003
    Posts
    20

    Smile How do I add the Hull ma to this Book?

    I found this very good stock buy and sell book from Gummy stuff. He adds that you can add your own calculation to the Book after column L5. Ok how I do this.

    http://www.financialwisdomforum.org/...lculations.htm

    This is such a complicated Worksheet I am lost where to start . I would like to add the Hull moving average to column AB 5.



    Any ideas please. And the gummy stuff has all types of stock stuffed in it.
    Thanks
    i2trader
    Last edited by i2trader; 02-14-2016 at 01:11 PM. Reason: forum rules

  2. #2
    Registered User
    Join Date
    10-14-2009
    Location
    orlando,Florida
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How do I add the Hull ma to this Book?

    Little help here I have found the VBA code for the Hull Moving Average.

    Here it is :

    http://finance4traders.blogspot.com/...g-average.html

    Now how do I add this subroutine to the Work book ? any Ideas please.

    http://www.financialwisdomforum.org/...lculations.htm
    Last edited by i2trader; 02-14-2016 at 01:13 PM. Reason: forum rules

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How do I add the Hull ma to this Book?

    Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    10-14-2009
    Location
    orlando,Florida
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How do I add the Hull ma to this Book?

    I am really not sure what needs to be done. The tag thing for the code is found where? I am not good at this stuff at all. Any help would be great.
    Last edited by i2trader; 02-14-2016 at 01:14 PM. Reason: mistake

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How do I add the Hull ma to this Book?

    Forum rules, link in the main menu bar, explain everything you need to know, i2.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How do I add the Hull ma to this Book?

    Do you know how to use a user-defined function?

  7. #7
    Registered User
    Join Date
    10-14-2009
    Location
    orlando,Florida
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How do I add the Hull ma to this Book?

    No I am a mere newbie I can do the little things but not the vba stuff or creating large marcos

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How do I add the Hull ma to this Book?

    If you post your workbook I'll add a user-defined function to it.

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How do I add the Hull ma to this Book?

    The workbook at https://app.box.com/s/dfsv8o8omn6x35j31nwtqvgw331adg3u contains a user-defined function for Hull's Moving Average and several examples of how to use it.

  10. #10
    Registered User
    Join Date
    10-14-2009
    Location
    orlando,Florida
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: How do I add the Hull ma to this Book?

    Thank you very much i will look at this and try to understand what is going on with it . So can I just copy and paste the work book for all to use and see? After all Mr gummy allows to use and rework any of his work has post that on his web page.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open Closed Book, carry out a VLookup and then put all entries into blank book
    By AChatwin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2015, 03:17 AM
  2. [SOLVED] how to change this macro so it makes sheets in a new book not in the current book
    By gavwalsh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2015, 05:27 AM
  3. Replies: 3
    Last Post: 12-27-2012, 12:26 PM
  4. [SOLVED] Populate time based on condition from Book 1 to Book 2....
    By [email protected] in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 12-12-2012, 01:52 PM
  5. Convex Hull
    By 19carlo56 in forum Excel General
    Replies: 3
    Last Post: 11-16-2012, 11:33 AM
  6. [SOLVED] Copy a range from one book, and transpose it to the next available line in another book
    By gherzberg in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-30-2012, 03:29 PM
  7. HULL MOVING AVERAGE Formula Needed
    By artiststevens in forum Excel General
    Replies: 3
    Last Post: 06-22-2011, 07:09 AM

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