Serving the Quantitative Finance Community

 
User avatar
eh
Topic Author
Posts: 3
Joined: March 2nd, 2010, 9:26 am

Powershell

April 8th, 2011, 7:57 am

Powershell: I write the odd DOS script and like to automate mundane tasks (mostly in VBA). I do not know unix and have no interest in maintaining a IT network. Would learning Powershell be useful? If so, what would it be useful for?
 
User avatar
afoster
Posts: 5
Joined: July 14th, 2002, 3:00 am

Powershell

April 8th, 2011, 9:01 am

What kind of mundane tasks? Firstly I would say install GnuWin32 tools on your system which will give you a whole load of command line goodness. I tend to automate things like backing up my local projects to a network server etc using a mix of python scripts and task sheduler.
 
User avatar
Hansi
Posts: 41
Joined: January 25th, 2010, 11:47 am

Powershell

April 8th, 2011, 9:50 am

Powershell is a pretty decent scripting language. I'd say the syntax is better than BATCH syntax but it's still a bit un-intuitive. The great plus over using BATCH is that you get full access to .NET built in assemblies and DLLs in an easy to use way.
 
User avatar
eh
Topic Author
Posts: 3
Joined: March 2nd, 2010, 9:26 am

Powershell

April 8th, 2011, 10:28 am

Cool. Thanks guys. I'll do a little more googling and think on it.