Skip to content

Instantly share code, notes, and snippets.

@RabbitJackTrade
RabbitJackTrade / effinInt.EXCEL.yaml
Created February 26, 2021 21:37
Calculates effin interest
name: effinInt
description: Calculates effin interest
host: EXCEL
api_set: {}
script:
content: |
/**
/* @CustomFunction */
function effIntPayPrd(nom_annaul_rate, num_int_periods, num_pay_periods) {
@RabbitJackTrade
RabbitJackTrade / pmv.EXCEL.yaml
Last active February 15, 2021 17:17
Create a new snippet from a blank template.
name: PMV
description: Calculate PMV formula
host: EXCEL
api_set: {}
script:
content: |
function pmv(investment, percentage) {
result = investment / percentage - investment;
return result;
}