GitHub

Excel VBA macro which run SQL to CSV file and to Excel file.

With this excel macro, you can run SQL to any text file (need to be either csv or tsv format), and get the result to the excel sheet or can export to csv file. It also contains "automation" ...
GitHub

Bond_Pricer_VBA_SQL

Keywords: VBA, SQL, Bond Pricing, Excel, Financial Analysis, Access Database, Risk-Free Curve, LIBOR Rates, Duration Calculation, Bond Cash Flows, Data Management ...
Microsoft

Running a SQL Stored Procedure from Excel (No VBA)

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...
The Earth Institute Columbia University

Coding for Risk Management: Excel VBA

Excel comes prepackaged with the VBA programming language. VBA is a straightforward programming language. A natural first step to learning VBA and coding in general is to rebuild models that are in ...
The Earth Institute Columbia University

Coding for Risk Management Seminar, Presented by the ERM Program

The Coding for Risk Management Seminar workshops get you started in Excel, VBA, R, Python, SQL, and GitHub. The first step in all of these languages is a big step; after taking it here, you will be ...