Actuarial Outpost
 
Go Back   Actuarial Outpost > Search Forums
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

DW Simpson International Actuarial Jobs
Canada  Asia  Australia  Bermuda  Latin America  Europe


Showing results 1 to 12 of 12
Search took 0.01 seconds.
Search: Posts Made By: Brad Gile
Forum: Software & Technology 07-03-2007, 10:02 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
I grok.

I grok.
Forum: Software & Technology 06-01-2007, 09:29 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
Um, a word to the wise here. This is a link to...

Um, a word to the wise here. This is a link to learning Visual Basic 5, which has not been sold for at least ten years (VB 6 is also no longer sold or supported either!):
Although VBA in Excel is a...
Forum: Software & Technology 05-28-2007, 06:14 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
Start with post #1 in this thread (which is aptly...

Start with post #1 in this thread (which is aptly titled, "Best way to learn VBA")!



These are all tools. The best way to learn any programming language is to practice writing code using good...
Forum: Software & Technology 12-20-2006, 08:49 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
Yup, that's indispensable. Get all VBA shortcut...

Yup, that's indispensable. Get all VBA shortcut keys at http://www.cpearson.com/excel/VBAShortcutKeys.htm

Brad
Forum: Software & Technology 08-14-2006, 05:06 AM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
DFA. Very useful for several lines or benefits...

DFA. Very useful for several lines or benefits that have correlated random variables. Shaun Wang, FCAS wrote a superb (and practical) paper on copulas a few years ago that should be mandatory reading...
Forum: Software & Technology 08-13-2006, 07:18 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
I had similar uses. Did you use copulas? Brad

I had similar uses. Did you use copulas?

Brad
Forum: Software & Technology 08-13-2006, 11:52 AM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
You have a macro that runs for 15 minutes? No, I...

You have a macro that runs for 15 minutes? No, I do not want to see the code. :D

Brad
Forum: Software & Technology 08-12-2006, 06:42 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
I used to do a lot of Monte Carlo simulation and...

I used to do a lot of Monte Carlo simulation and modeling work. Now I'm retired but still use Excel VBA for number theory stuff and other math play.
For heavy duty stuff I use Mathcad.


Brad
Forum: Software & Technology 08-11-2006, 06:37 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
OK. Brad

OK.

Brad
Forum: Software & Technology 08-11-2006, 03:14 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
But my point, which you ignore, is that a lot of...

But my point, which you ignore, is that a lot of people generate the code with the recorder and routinely use it as is! Often, when this is done, the code will not always work they way the user...
Forum: Software & Technology 08-10-2006, 05:19 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
Unfortunately, many actuaries using VBA have done...

Unfortunately, many actuaries using VBA have done the same thing, with the following results:
1. Crap code - sometimes from the recorder, sometimes from the bliss of ignorance of the coder.
2....
Forum: Software & Technology 08-09-2006, 07:33 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 197,050
Posted By Brad Gile
In addition, write a ton of experimental code to...

In addition, write a ton of experimental code to see
(1) what it does,
(2) what it does NOT do,
(3) what unexpected things it does.

Then find ways to modify that code to make it stable and...
Showing results 1 to 12 of 12

 

All times are GMT -4. The time now is 09:34 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, 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.14103 seconds with 7 queries