Actuarial Outpost
 
Go Back   Actuarial Outpost > Exams - Please Limit Discussion to Exam-Related Topics > SoA > Fellowship Modules > Financial Economics
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 07-07-2017, 06:21 PM
kittens kittens is offline
Member
SOA
 
Join Date: Jul 2011
Posts: 1,059
Default Excel file for task 1

I am in the process of doing the hedging errors for task 1 and it seems I am either going to have to make a lot of tabs or have tabs with hundreds of rows in order to calculate the stock prices and hedging error components. Is this the case for anyone else? How did you handle it, just paste each table in appendix?
Reply With Quote
  #2  
Old 10-04-2017, 03:11 AM
Viki2011's Avatar
Viki2011 Viki2011 is offline
Member
SOA
 
Join Date: Oct 2011
Posts: 261
Default

Hi kittens,

I just started with task 1 but got stuck. The assignment refers to specific excel spreadsheets that we are supposed to use but I don't have the same names in my excel spraedsheets. Am I missing something? Maybe the spreadsheets are renamed and the excel ss name that Pamela is asking to work with is out of date?

Please help!
Reply With Quote
  #3  
Old 10-12-2017, 06:53 PM
kidactuary's Avatar
kidactuary kidactuary is offline
Member
SOA
 
Join Date: May 2013
Studying for FAP
College: UMN
Posts: 81
Default

Quote:
Originally Posted by Viki2011 View Post
Hi kittens,

I just started with task 1 but got stuck. The assignment refers to specific excel spreadsheets that we are supposed to use but I don't have the same names in my excel spraedsheets. Am I missing something? Maybe the spreadsheets are renamed and the excel ss name that Pamela is asking to work with is out of date?

Please help!
Did you figure out your problem?
Reply With Quote
  #4  
Old 10-29-2017, 09:25 AM
Viki2011's Avatar
Viki2011 Viki2011 is offline
Member
SOA
 
Join Date: Oct 2011
Posts: 261
Default

yes. I'm doing task 1 now.
Reply With Quote
  #5  
Old 01-17-2018, 11:01 AM
bcfish bcfish is offline
Member
 
Join Date: Jan 2011
College: tsinghua postgraduatae
Posts: 39
Default

The same questions here. What I have in the workbook are two tabs, one holds the simulation output for RSLN model and the other for LN model.
- Are we supposed to come up with all the calculations for HE, including implementing the Black-Scholes formula?
- Since we need do it for 50+50 scenarios, I am thinking to write a macro. But is macro allowed?

Thanks!
Reply With Quote
  #6  
Old 01-17-2018, 11:28 AM
bcfish bcfish is offline
Member
 
Join Date: Jan 2011
College: tsinghua postgraduatae
Posts: 39
Default

Never mind! Found the answers to my questions in older posts,
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 07:43 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.33539 seconds with 11 queries