Hoadley + VBA -- need help?

Discussion in 'Trading Software' started by MYDemaray, May 29, 2005.

  1. I'm trying to run some simple VBA using the Hoadley plugin in excel. I'm trying to simply return the HoadleyHistoricVolatility. I'm using the following and it isn't computing. Anyone have some thoughts?

    Sub Trial()

    Dim result As Double

    result = HoadleyHistoricVolatility("C", 0, 0, 0, Array("price"), 0, 252)

    End Sub

    I'm not sending the result anywhere yet, but when I hover over the code I find that "result"=0.

    Using the same array in Excel, I've been able to run the function and get a result, in the same workbook. The "HoadleyOptionsAddin" is selected in my References manager.