Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Salary Surveys
Property & Casualty, Life, Health & Pension

Health Actuary Jobs
Insurance & Consulting jobs for Students, Associates & Fellows

Actuarial Recruitment
Visit DW Simpson's website for more info.
www.dwsimpson.com/about

Casualty Jobs
Property & Casualty jobs for Students, Associates & Fellows


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12-15-2017, 04:26 PM
BassFreq's Avatar
BassFreq BassFreq is offline
Member
CAS
 
Join Date: Jun 2003
Location: Chicago
Studying for all eternity
Favorite beer: Duff
Posts: 1,708
Blog Entries: 2
Default Microsoft Considers Adding Python in Excel

From https://www.bleepingcomputer.com/new...uage-to-excel/

Quote:
Microsoft is considering adding Python as one of the official Excel scripting languages, according to a topic on Excel's feedback hub opened last month.

Since it was opened, the topic has become the most voted feature request, double the votes of the second-ranked proposition.
__________________
If at first you don't succeed, you have one data point.
Res ipsa loquitur, sed quid in infernos dicet?
Reply With Quote
  #2  
Old 12-15-2017, 04:43 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,660
Default

Quote:
Originally Posted by BassFreq View Post
I don't know what "scripting language" means. Are they going to allow macros to be written in python instead of VBA? Or is it something else.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Nov. 20, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by El Actuario View Post
Therapists should ask the right questions, not give the right answers.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #3  
Old 12-15-2017, 07:57 PM
xpg's Avatar
xpg xpg is offline
SOA AAA
 
Join Date: Dec 2017
Posts: 2
Default

Microsoft extended Office functionality via introduction of "web apps" in Excel 2013. The over use of the phrase "web apps" is terribly confusing to most people and also to developers.

"Web app" in current Microsoft Office development terminology, means extending functionality by providing a web service (html,css) data exchange mechanism which can interact with data on the worksheet or any other office application etc. Typical examples include some sort of look-up of simple external data which is brought into the Excel workbook via "web app."

By adding python script capability on server side, richer functionality [(function, data) rather than just "data" ] becomes available using Excel as user interface via web app feature. This is separate and distinct from Excel's current extension: VBA , dll and .Net(HPC).

If you are curious, videos for (actuarial/machine learning) Excel web apps: 1.) stochastic trend volatility 2.) stochastic reserve can be found at www.ihaconsultants.com.
Reply With Quote
  #4  
Old 12-15-2017, 11:17 PM
Arlie_Proctor Arlie_Proctor is offline
Member
CAS AAA
 
Join Date: Dec 2001
Location: N.J.
College: Indiana University
Favorite beer: Becks
Posts: 1,197
Default

Oh lord, can we find any more ways to bloat Excel and make it any less transparent and stable?
Reply With Quote
  #5  
Old 12-16-2017, 09:45 AM
jas66Kent jas66Kent is offline
Member
SOA
 
Join Date: May 2012
Location: London
Favorite beer: Corona :)
Posts: 22,630
Default

Quote:
Originally Posted by Arlie_Proctor View Post
Oh lord, can we find any more ways to bloat Excel and make it any less transparent and stable?
I ran into this problem before.

It was only really meant for mild-moderate modelling at best.

Now companies build their entire model in excel which makes for enormous, cumbersome workbooks that are incredibly laggy. They also limit your flexibility in as far as what you can do model-wise.

I get that pretty much everybody will know a good amount of excel, but a company really has to be forward thinking here and develop heavy duty modelling capabilities which do not use excel. This as an expense (commercial licenses can be expensive) but in the long run it is well worth it as you can reduce the operational risks of increasingly cumbersome workbooks.
Reply With Quote
  #6  
Old 12-16-2017, 04:19 PM
30pcssilver 30pcssilver is offline
Member
SOA
 
Join Date: Jun 2013
Location: Far East
Posts: 282
Default

Quote:
Originally Posted by xpg View Post
If you are curious, videos for (actuarial/machine learning) Excel web apps: 1.) stochastic trend volatility 2.) stochastic reserve can be found at www.ihaconsultants.com.
Was that website built by an ex-Angelfire employee? Thumbs-down
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:10 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.35794 seconds with 11 queries