Front/Back Office Application Support, C, C#, Perl, Python, SQL, Unix

7 SQL performance technics

 1. Don't use UPDATE instead of CASE
This issue is very common, and though it's not hard to spot, many developers often overlook it because using UPDATE has a natural flow that seems logical.

 

PV & VFC

VFC (Value of Future Cash flows) is an estimate of the value of a deal at this moment in time, based on its known or expected future returns and obligations, and given the prevailing market circumstances.
PV (Present Value) means the same thing as VFC (except for positions in exchange-traded futures, where the concept of “value” is in any case somewhat tricky).
VFC is the term preferred

Natural logarithm definitions

Natural logarithm

 

e is the natural logarithm,

e = 2.718281828.

e^{\ln(x)} = x \qquad \mbox{if }x > 0\,\!

 

\ln(e^x) = x.\,\!

 

 \ln(xy) = \ln(x) + \ln(y) \!\,

 

\ln(1) = 0\,

The Black and Scholes Model

The Black and Scholes Model:

The Black and Scholes Option Pricing Model didn't appear overnight, in fact, Fisher Black started out working to create a valuation model for stock warrants. This work involved calculating a derivative to measure how the discount rate of a warrant varies with time and stock price. The result of this calculation held a striking resemblance to a well-known heat transfer equation. Soon after this discovery, Myron Scholes joined Black and the result of their work is a startlingly accurate option pricing model. Black and Scholes can't take all credit for their work, in fact their model is actually an improved version of a previous model developed by A. James Boness in his Ph.D. dissertation at the University of Chicago.

Calculating delta - interest rate derivatives

 

EXAMPLE #1:  Plain Vanilla Swap

The first example uses a $100 million notional vanilla swap paying USD Fixed and receiving USD LIBOR.

How to hedge this trade – 5 STEPS TO HEDGING:

Black–Scholes formula

 The Black Scholes formula calculates the price of European »

Delta risk on interest rate derivatives

Delta risk on interest rate derivatives

The concept of delta risk on interest rate derivatives is a generalization of the traditional one of a single asset option. However, contrary to single asset derivatives, fixed income derivatives are derivatives depending on a variety of instruments, used in the determination of the interest rate curve, rather than a single asset. The delta risk measures precisely the risk associated with the shift of the interest rate curve. Because there are many ways of shifting the interest rate curve, many different deltas can be computed. The most common ones are the following:

list all files that have been modified today

find ./foundry_*SCRIPTED09* -type f -mtime -1 -print

 

Unix move files older than 7 days

find . -type f -name "*.caf" -mtime +7 -exec mv {} backup/ \;

5 Greeks and Corresponding Sensitivities

 

Greek              Measures option price sensitivity to changes in:

Delta               Underlier Price

Gamma            Underlier Price

Vega                Underlier Volatility

Theta               Time to Expiration

Rho                   Interest Rate

 

 

Syndicate content