PDA

View Full Version : coding for custom function



anandbohra
02-18-2008, 04:29 AM
Hi friends

I am putting my feet in sql shoes so pl help me

I am creating the daily returns of my scrips
the returns are log returns so does anybody knows code for getting log returns in SQL as I searched for inbuild fucntion but fails to get the same but the same is provided by excel [ ln() ]

pl help me

Trevor
02-18-2008, 04:18 PM
http://www.sqlservercentral.com/articles/Miscellaneous/2689/ try this I don't know if it is exactly what your looking for but I think it may be close

XLGibbs
03-04-2008, 05:43 PM
You would probably need to post a sample of the data and results expected, or more clarity to the actual problem...