Search for project
More than 2000 projects issued through our platform and this
amount increases very fast.
vba programming (ID:3714)
| Project Creator: |
creesi
FC Member For 6257 Days
Credits 20 Completed Proj. Num. 0 / 5 Total payment USD 500.00 Avg Daily Online 0.00 h (From 21/5/2007) Available on MSN/Skype Yes Last Login 4/17/2008 Peers Rating 0.00% 
|
|---|---|
| Budget: | Not Sure/Confidential |
| Created: | 1/8/2008 6:35:11 PM EST |
| Bidding Ends: | 1/23/2008 6:35:11 PM EST ( Expired ) |
| Development Cycle: | 21 Days |
| Bid Count: | 7
|
| Average Bid: | 1,379.29 |
| Project Description:
this program needs to be able to calculate the value at risk for any combination of up to fur companies.the project should be able to accept anything up to and including four companies.the tock prices of companies of up to 3 years of daily stock prices should be able to be accepted but no more tha this amount.the stock prices should be turned into returns and from this point the relevant inputs for the value at risk calculated. an efficient frontier is to be shown in risk / return space to graphically illustratethe findings. specifics the program should be presented through userforms.i want there to be a menu which has the buttons 'VAR', 'credits' and 'about this program'. when clicked on for each, new userforms should open up. when VAR is opened up i want tabs to be used. for each tab should represent each input needed to calculate the value at risk i.e. average share price(mean), standad deviation variance covariance matrix confidence interval unwind period etc. i would like input boxes of some sort asing for the inputs of the share prices depending on the amount of companies required y the user. i want the weights to distributed evenly if possible, (always add up to 100%). the calculations i would like to e done without the user seeing what is going on. i would also like the calculations to be shown on a spreadsheet (for more advanced users) to show all the numbers etc.this must be a flawless procedure with the relevant constraints for the inputs i.e no text characters allowed no other data other than the relevant data allowed. error message explaining what data needed etc. the final label displays the value at risk and a graph plotting an efficient frontier. it needs to highlight the link between the value at risk and the corresponding mnimum variance portfolio.wouls also like to show the optimal portfolio with the use of the capital market line. (open to suggestion) if credits are clicked on then i wuld like a label stating who i would like to credit for this project. put in any name and i will change it at a later date if 'about this project' is clicked on then i would like a label or something to a fancy effect to be displayed saying what this program does and how it is designed to help ppl. each userform is to have an unload function to return to the main menu (open to suggestions). all code in this program must be fully annotated and all functions must be explained as to why they were used similarly with any loops or complictaed nested loops. a user manual is to be created for the program which displays how to use the program.must be easy to read but have a section for the more advanced of users as to what the spreadshet information means if he/she wishes to look at. this work must be performed to the HIGHEST standard.the equivalent of an A or a 1st to best illustrate the standard looked for. Newly added descriptions: between 250$ and 500$ |
|
| Job Type | Visual Basic |
| Attached Files: | N/A |
