Results 1 to 6 of 6

Displaying Binomial trees in excel

Threaded View

darklide Displaying Binomial trees in... 03-10-2010, 09:33 AM
darklide Re: Displaying Binomial trees... 03-13-2010, 08:47 AM
Andy Pope Re: Displaying Binomial trees... 03-13-2010, 09:17 AM
darklide Re: Displaying Binomial trees... 03-13-2010, 10:35 AM
Andy Pope Re: Displaying Binomial trees... 03-13-2010, 11:36 AM
darklide Re: Displaying Binomial trees... 03-13-2010, 12:05 PM
  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    5

    Displaying Binomial trees in excel

    Hi all,
    First of all im sorry if such a thread exists...

    What i wanted to know if anyone knows a way to display data in excel(using VBA), where the data is in a binary tree form, as follows:

    \1

    The no of periods can vary from 3-10 periods ( or more at times)

    What i want is to either have a way to display it as follows:

    \1

    But as be able to have trees of different size plus be able to include some info such as the no of periods(at the bottom of each column) and be able to add the initial data from which the data was created. (the code i used above to create a tree like that has two problems: 1. i cant put any labels such as the no of periods and such 2. i need a button to return back to the userform from which the data was taken)

    OR
    if the above is not possible, i need a way to have a user form the data as it is in the worksheet. Ive thought of textboxes but then i'll have LOTS of them to put since i have about 10 worksheet with different trees of different size

    Thx in advance for answering
    Last edited by darklide; 03-10-2010 at 09:38 AM.

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