SEARCH Excel at Finance

Google custom search



TOPIC index Excel at Finance

A
ActiveX controls: ToggleButton ... [VBA]
AddNameRelative: macro ... [VBA]
Address of first and last cell in range
Animation - with audio ... [VBA] Draft 09Oct16
Animator v3.1 xlsm
Advanced filter: holidays
Array VBA basics ... [VBA]
Array dimensions - limit ... [VBA]
Array dimensions - number ... [VBA]
Array formulas element by element
Arrays, subarrays: application tax ... [VBA]
Array to named array constant ... [VBA]
ASX non trading days
ATP covariance dialog box - step 1 ... [VBA]

B
Banner: add blue ... [VBA]
Banner: add logo ... [VBA]
Ben and Siew's housing loan
Binary addition: xlfBinAdd1 function ... [VBA]
Black-Scholes: function ... [VBA]
Black-Scholes: Google sheets & GAS ... [GAS]
Black-Scholes: on the HP 10bII+
Box cancel button coding ... [VBA]
Business day - next or previous

C
Calendar array formula NEW
Calling private procedures ... [VBA]
Char: function
Chart: price - volume
Chart: price - volume [v2: 2013]
Chart: price - volume [v3: 2010]
Chart: X-Y scatter plot
Clock and Time Macros ... [VBA] NEW
Colours (1): ColorIndex, RGB and Color ... [VBA]
Controls WS - lists
Convert lower triangular table to full matrix
Copy Paste ... [VBA]
Count decimal places ... [VBA]
Count cells with error values
Ctrl+Shift+A

D
Data analysis: subtotals
Data validation w/ multiple lists
Date comparisons: spreadsheets
Decimal place keyboard shortcut ... [VBA]
Descriptive statistics, and covariance
Dialog boxes - BuiltIn ... [VBA]
Dialog box launcher
Does sheet exist? ... [VBA]
Dynamic range: Data M
Dynamic range: DateV

E
Excel errors
Excel function keys
Exponents: rules
Exercise: Add new WS from List ... [VBA] NEW
Exercise: Array power 2 ... [VBA]
Exercise: Functions (session 8) ... [VBA]
Exercise: Price to return ... [VBA]
Exercise: Worksheet controls ... [VBA]

F
Fill handle mode
FillHdlDblClk: macro ... [VBA]
Floating point precision, and cell formats
For...Next statement ... [VBA]
Function keys: Excel
Functions with array arguments

G
Geometric Brownian motion - quick guide ... [VBA]
GetCF: WS function ... [VBA]
GetDVEnumName: function ... [VBA]
GetDVListSource: function ... [VBA]
GetFT: WS formula ... [VBA]
GetScreenResolution: macro ... [VBA]
GetSelectDim: macro ... [VBA]
GetSheetList: macro ... [VBA] NEW
GetTextInArray: function ... [VBA]
GetWS2UFcolor: function ... [VBA]
GetXLver: macro ... [VBA]

H
Histogram of stock returns with normal curve overlay

I
Icons - MsgBox and Data Validation ... [VBA]
If...Then...Else statement ... [VBA]
Implied volatility and Goal Seek ... [VBA]
Input box method w/ Black-Scholes model ... [VBA]
Input box method (2) delimited parameters ... [VBA]
Input box method default parameter (type 8) ... [VBA]
Interest rate collar
Interest rate risk - gap analysis
Interest: simple and compound
Interpolation: last known value (LKV)
Interpolation: linear with formulas
Is date in range of dates ... [VBA]
Iteration with bisection ... [VBA]


K
KMV's sigma: a note

L
Logical functions: worksheet
Line-continuation limit ... [VBA]

M
Macros: require user to enable ... [VBA]
Match function: with dates
Merton model of risky debt
Monte Carlo: function ... [VBA]

N
Name box
Name character limit ... [VBA]
NetPV engine ... [VBA]
NPV calculation in table form

O
On sheet spinner and text box xlsx
Offset: function
Opening macro enabled workbooks
Option delta: function ... [VBA]
Out of data alert

P
Paste list of defined names
Percentage arguments: function ... [VBA]
Pointers (Excel) and the fill handle
Portfolio analysis pdf
Power Map → Tours
Power Query → Get & Transform
Power View (Reports) and Power BI Report View
Project submission

R
Random numbers N(0,1) with X-Y scatter plot
Range to Array to CSE ... [VBA]
Range object (1) ... [VBA]
Range object (2) ... [VBA]
Rate of return
Reference styles
Resolution: set Excel to 720p ... [VBA]
Ribbon - XML ... [VBA]

S
Scope - VBA variables and constants ... [VBA]
Select Case Statement ... [VBA]
SetFormulaBarText: macro ... [VBA]
ShapeType assigned to VBA array ... [VBA]
Sort SheetList and WS w/ onSheet controls ... [VBA] NEW
Sort SheetList and WS - ver. 2 ... [VBA] NEW
Splash screen xlsm
Standard normal probability tables
Sub procedures ... [VBA]

T
Trailing minus numbers ... [VBA]
Text: function
Triangle numbers ... [VBA]

U
User Defined Functions ... [VBA]
User Defined Function error handling ... [VBA]
User Form - Calculator program example ... [VBA]
User Form - Controls collection ... [VBA]
User Form - Initialize objects ... [VBA]
User Form - Multiplication program example ... [VBA]
User Form - Mult. program - KeyPress version ... [VBA]
User Form object naming conventions
User Form - TextBox numeric prefilter ... [VBA]

V
Validate sheet name ... [VBA]
Validate TextBox entry ... [VBA]
VBA dates xlsm
VBA numbers - integer to floating-point ... [VBA]
VBA time concepts ... [VBA]
VBA variables (1) ... [VBA]
VBA versions ... [VBA]
VBE interface ... [VBA]
VBE code window elements ... [VBA]
Vector to array ... [VBA]
Vector to array constant... [VBA]
Vlookup w/ indirect

W
What version of Excel am I using?
Windows: region settings
Windows: voice settings ... [VBA]
Worksheets: add from list ... [VBA] NEW
Worksheet: name exists ... [VBA]
Worksheet: sort ... [VBA]
Worksheet cells
WWW price data download

X
xlfSplit function... [VBA]


CONTACT Excel at Finance



FOLLOW Excel at Finance