Pages

▼
Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Use a Python script to read and write on Excel File in Python

›
This post demonstrates how to utilize the xlwings Python package to execute a Python script to read and write Excel in Python . ...

Executing a Python script within Excel using xlwings

›
This post demonstrates how to utilize the xlwings Python package to execute a Python script within Excel .

Excel: Converting String Date to Date Type

›
This post demonstrates how to convert a string-formatted date to a Date type using three Excel formulas.

Excel : Split the given string by underscores and select the n-th element

›
This post shows how to split the given string by the underscores and select the nth element using Excel functions.

Excel : the first and last day of month with and without weekends or holidays

›
This post shows how to determine the first or last day of a month taking weekend or holidays into account using Excel function...

Excel : Scan Numeric Data From a Time Series Plot Image

›
This post introduces a very nice scanning excel tool for scanning numerical values approximately from a plot image . We sometimes...

Simpler and More Convenient Linear Interpolation in Excel

›
This post presents a simpler and more convenient Excel formula for the linear interpolation without VBA Macro. This is particular...

Run Excel Solver multiple times : Period-by-Period Estimations of Nelson-Siegel model

›
This post shows how to run an Excel solver using VBA macro multiple times. As an example, we take period by period estimations ...

Excel Solver using VBA macro : Nelson-Siegel yield curve fitting

›
This post shows how to run an Excel solver using VBA macro. If the number of optimization problems are more than two, every tim...
2 comments:

Generating Dynamic Multiple Excel Charts by using VBA macro

›
This post combines a dynamic chart and multiple charts, both of which are covered in two previous post. The purpose of this work...

Dynamic Excel Chart by using VBA macro

›
This post shows how to make a dynamic chart using Excel VBA macro. This dynamic chart adjusts graphs automatically when a lengt...

Generating Excel Charts with different data while keeping the same format and style

›
This post shows how to generate multiple Excel charts with the same format and style. As the number of charts increases, it is ...

R : httr in R and MSXML2.ServerXMLHTTP in Excel VBA

›
This post shows a R counterpart of Excel VBA's MSXML2.ServerXMLHTTP related commands with which server APIs are called easily. In ...

Bond Convexity in Excel and R

›
A convexity is needed to describe a non-linearity of a bond price, which is absent in a duration. This post explains the meaning and ca...

Bond Modified Duration in Excel and R

›
Bond duration is a basic building block for bond portfolio management and asset-liability management (ALM). This post explains the mean...

Excel : VLOOKUP with a vector of lookup values

›
This post presents an advanced Excel technique for the quadratic form matrix calculation accompanying cross products with correlation. ...

Pricing of FX Forward in R and Excel

›
This post explains how to price a FX forward. We assume that 1) USD is the foreign currency and KRW the domestic one, 2) USD IRS ze...
2 comments:

Simple Linear Interpolation without VBA Macro in Excel

›
This post presents a simple but useful Excel formula for the linear interpolation without VBA Macro. This is most frequently used espec...

RDCOMClient : read and write Excel, and call VBA macro in R

›
This post gives an short introduction to the RDCOMClient R package, which provides a variety of functionalities. Our focus is on readi...
4 comments:

How to Use Obba for a link between Java and Excel

›
This post shows the step by step guide on how to use Obba. Obba is a Java object handler for excel spreadsheet applications. Obba docum...