Function Creation, mapping strike to options format

[jb09]

Hey all,

I have created a simple function called "test":

Function test(Ticker, year, month, dt, strike)
If Len(month) = 1 Then month = "0" & month
If Len(dt) = 1 Then month = "0" & month

test = Ticker & year & month & dt & "C" & strike & "U"

End Function

-------------------------------------------------------------------

I am having an issue with strike. Strike is looking in the spreadsheet to a column which has downloaded the strike price of the option. This may be listed as 8.00, 8.65, 80, 80.60, 86.50, 180.00, etc etc. The format that this needs to be in 00086000 if the strike was 86. For 86.50 strike it would be 00086500U; 186.00 = 00186000 etc etc. What i am trying to do is allow the function to identify the strike, and then output the desired format as listed earlier.

If you would need a spreadsheet attached to this I can post it as well, but this is essentially what I am trying to do. I appreciate any assistance and if i need to explain further i will!

Thanks

 

[jb09]

Forgot to add that i am using excel 2007, thanks!