Rewrite Excel VBA functions into Excel functions

Hi, I need your help to rewrite the Excel VBA function to Excel functions PLEASE READ CAREFULLY BEFORE YOU BID ON. You should have solid knowledge and experience in both Excel VBA functions and Excel functions. I have attached 4 excel files here, the first 3 files are '[login to view URL]', '[login to view URL]' and '[login to view URL]', which contains functions written in VBA. The second file is '[login to view URL]', in which you should rewrite the functions into Excel functions. You need to rewrite 17 VBA functions located in '[login to view URL]', '[login to view URL]' and '[login to view URL]' into Excel functions located in stocks.xls. However, the first one (SMA) is already rewritten and show you as an example. Functions should be rewritten as simple as possible, but number of columns used are NOT restricted. The deadline is 10 days, no extension is allowed. Rgds, Nic