0. Login: bmkim/L?ngst*in | root/L?ngst*in 1. Install Ubuntu Desktop @ 20160317 2. Hadoop v2.6.3 Installed with footprint @ 20160408 >> ** hduser/L@…. >> su -hduser >> ssh … >> ssh localhost >> … @ http://www.inspint.com.au/salm/2016/04/16/rhadoop-installation-and-configuration-footprint-native/ 3. R Studio server (64-bit)…
KMatrix
Sub vbTest() MsgBox KMatrix(“57031”, “57039”, “Sheet1”, 1, 2) End Sub ‘################################################################################################################### ‘### KMatrix () ‘### Purpose: Get a value by means of intersection of row and column ‘### Parameter: sItemFrom, sItemTo, sShtMarix,iColumnNumberForSearch, iRowNumberForSearch ‘### Author: David Kim ‘### Version: 3.0…
Black-Scholes Formula (d1, d2, Call Price, Put Price, Greeks)
This page explains the Black-Scholes formulas for d1, d2, call option price, put option price, and formulas for the most common option Greeks (delta, gamma, theta, vega, and rho). If you want to use the Black-Scholes formulas in Excel and…
CMatrix
Const CLEANING_MATRIX_LINE19_BAGGER1_WSHT = “CM-L19-B1” Const CLEANING_MATRIX_LINE19_BAGGER2_WSHT = “CM-L19-B2” Const CLEANING_MATRIX_LINE18_BAGGER1_WSHT = “CM-L18-B1” Const CLEANING_MATRIX_LINE18_BAGGER2_WSHT = “CM-L18-B2” Const CLEANING_MATRIX_LINE5_WSHT = “CM-L5” Const CLEANING_MATRIX_MIX_ROOM_WSHT = “CM-MixRoom” Sub vbTest() ‘MsgBox CMatrix(“21233”, “21243”, CLEANING_MATRIX_LINE19_BAGGER1_WSHT) ‘MsgBox CMatrix(“32042”, “32040”, “CM-L5”) MsgBox CMatrix(“57031”, “57039”, “CM – Waterwheel”,…
Black-Scholes Formula (d1, d2, Call Price, Put Price, Greeks)
This page explains the Black-Scholes formulas for d1, d2, call option price, put option price, and formulas for the most common option Greeks (delta, gamma, theta, vega, and rho). If you want to use the Black-Scholes formulas in Excel and…
How to Read/Write BLOB from/to Database
Option Explicit Const BlockSize = 32768 ‘************************************************************** ‘ FUNCTION: xlWriteBLOB() ‘ ‘ PURPOSE: ‘ Writes BLOB information stored in the specified table and field ‘ to the specified disk file. ‘ ‘ PREREQUISITES: ‘ The specified table with the OLE…
Excel VBA: Insert Excel Range To Database
‘ Option Explicit Sub RangeToDatabase_Test() RangeToDatabase “C:\Temp\HLC\Prototype\RangeToDatabase\HLCDB.mdb”, “HLC” End Sub Sub RangeToDatabase(psDBPath As String, psTableName As String) ‘Sub RangeToDatabase() ‘Macro purpose: To add record to Access database using ADO and SQL ‘NOTE: Reference to Microsoft ActiveX Data Objects Libary required…
Saving Excel File into Access Database
How To Read and Write BLOBs Using GetChunk and AppendChunk Option Explicit Const BLOCK_SIZE = 16384 Sub BlobToFile(fld As ADODB.Field, ByVal FName As String, _ Optional FieldSize As Long = -1, _ Optional Threshold As Long = 1048576) ‘ ‘…
Math2.org: Math Tables: Areas, Volumes, Surface Areas
Areas square = a2 rectangle = ab parallelogram = bh trapezoid = h/2 (b1 + b2) circle = pi r 2 ellipse = pi r1 r2 triangle = (1/2) b h equilateral triangle = (1/4)(3) a2 triangle given SAS =…
Implied Volatility in 3-D
Summary An implied volatility surface is a three-dimensional plot that reveals implied volatility data for a number of different options series for a particular underlying security. This paper introduces a “near real-time” version of such a surface, which dramatically facilitates…