Thread: tree chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Quant Quant is offline
external usenet poster
 
Posts: 1
Default tree chart


I have a homework assignment for a finance class that requires building a
binomial tree. The tree has been built in excel cells as illustrated below
with stock prices and option prices. Although not a requirement for my
class, I was wondering if it is possible to plot this distribution on a
chart.

50 45 40 xxx
55 50 xxx
45 xxx
xxx

3.0 2.5 2.3 xxx
3.5 3.0 xxx
3.4 xxx