financial analysis with microsoft excel 2019

Road map to the xlf-ymd-selector file - contains both Data Validation and Form Control versions of the Year-Month-Day worksheet selector interface WIP.

WS date - UNIX timestamp - added From Web URL string for /v7/finance/download.

YMD WS date picker - Data Validation and Form Control versions of the Year-Month-Day worksheet selector interface - published version.

xlf :: VBA add a thermometer chart to the WS - a Quick Guide to the VBA needed to add a 'thermometer chart' to a WS.

VBA sample question - ATO CorpTax - ATO company tax rates → User Defined function (UDF).

Exchange non trading days - ASX & NASDAQ - added calendar for 2022.

VBA - xlfDateToSerialNumber - ISO yyyymmdd date to serial date using mathematical operators, logic statements, and code control procedures.

VBA - Days Count - Actual, European and NASD methods using mathematical operators, logic statements, and code control procedures.StockReturn - a simple VBA function - Log, Discrete, Option method, #Value error DemoIBCR - a VBA sub demonstration - InputBox method was CurrentRegion as Default value.

Financial analysis with microsoft excel 2019