C'mon people... is this no longer a share and learn community, or are all the experts gone from here ?!?!

Sure there still are people on this forum to answer student's questions... Pls. prove me I am right.

Anyone on this question ?

<t>Hey people, one dumb question: Would the results be very different if dividends were implied directly from futures prices, instead of puts and calls ? Would this approach imply different assumptions / models ? Thanks for your help, </t>

<t>thank you guys. Actually I found a macro that does this : the only problem is that the number of values that can be taken is limited. '#########################################################' First place the data in two columns and select the corresponding rangeSub Graphwithoutlink()Application...

Hi, I have a variant named "My_Matrix" with 5 columns and n lines, I would like to create a graphe with it, what would be the " .SetSourceData Source:=" statement for that ? Thanx for your help,

QuoteOriginally posted by: InMyWoodenHutThanx, Does not work on my PC... I have to check a few other possibilities.actually it does work : GREAT ! BUT not if the range that is changed contains a Scroll down list (using data / validation ...) which is my case... oh well...

Thanx, Does not work on my PC... I have to check a few other possibilities.

Thanx, that is the idea but mine is not a listbox, it is a dropdown box. Besides, the box is directly in my excel sheet, not in a userform, does that change anything ?

<t>Hi, I have a drop down list in my spreadsheet, and I would like to get the selected value. I associated the following macro to it, but it does not get the "DropDown1.value " : Sub DropDown1_change()MsgBox ("Index1 changed")Sheets("Sheet1").range("A1").Value = "Index : " & DropDown1.valueEnd S...

ok, I got it. This kind of code only works if the graph is an object in a sheet, and not in a sheet of its own.

I don not know whether it works on your PC ... On mine it doesn't thank you anyway... any other suggestions ?

Hi I would like to count the number of series in an excel graph, through VBA code. I tried the following but it does not work .... (the graph itself is in a sheet) Sheets("myChart").Activate ActiveChart.SeriesCollection.Series.Count Can anyone help me out ? thanx IMWH

thank you for the insight, but for the moment I will concentrate on the basic aspect of the question i.e. how to generate several spot paths with the conditions mentionned below ... Any clue on this ? ThxIMWH