Skip to content

Instantly share code, notes, and snippets.

@mckoss
Last active April 12, 2017 17:41
Show Gist options
  • Select an option

  • Save mckoss/0971e8f818062e2b5dc41b7a33496c60 to your computer and use it in GitHub Desktop.

Select an option

Save mckoss/0971e8f818062e2b5dc41b7a33496c60 to your computer and use it in GitHub Desktop.

Revisions

  1. mckoss revised this gist Apr 12, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion vs_purchase-help.md
    Original file line number Diff line number Diff line change
    @@ -14,4 +14,4 @@ The results of the function will fill in two columns for each sale in the range:
    - **Basis** - Total amount paid for share sold.
    - **Versus** - List of purchases which this sale is paired with (displaying: shares@price (date))

    See [Example Sheet](https://docs.google.com/spreadsheets/d/14zrdNfC9cea_2xsvMqcnl923z0mNErH1X97rmKNpQe0/edit#gid=0)
    See [Example Sheet](https://docs.google.com/spreadsheets/d/14zrdNfC9cea_2xsvMqcnl923z0mNErH1X97rmKNpQe0/edit#gid=0).
  2. mckoss revised this gist Apr 12, 2017. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion vs_purchase-help.md
    Original file line number Diff line number Diff line change
    @@ -12,4 +12,6 @@ to preserve first-in/first-out ordering of transactions). The three columns sho
    The results of the function will fill in two columns for each sale in the range:

    - **Basis** - Total amount paid for share sold.
    - **Versus** - List of purchases which this sale is paired with (displaying: shares@price (date))
    - **Versus** - List of purchases which this sale is paired with (displaying: shares@price (date))

    See [Example Sheet](https://docs.google.com/spreadsheets/d/14zrdNfC9cea_2xsvMqcnl923z0mNErH1X97rmKNpQe0/edit#gid=0)
  3. mckoss revised this gist Apr 12, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion vs_purchase-help.md
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,7 @@

    _Custom Function to compute versus purchase gains (FIFO)._

    The passed range should contain exactly three coloumns of data (in chronological order
    The passed range should contain exactly three columns of data (in chronological order
    to preserve first-in/first-out ordering of transactions). The three columns should contain:

    - **Date** can be an actual date or id string (but rows of the range must be chronological).
  4. mckoss revised this gist Apr 12, 2017. 1 changed file with 10 additions and 7 deletions.
    17 changes: 10 additions & 7 deletions vs_purchase-help.md
    Original file line number Diff line number Diff line change
    @@ -1,12 +1,15 @@
    # VS_PURCHASE(range) - Custom Function to compute versus purchase gains (FIFO).
    # VS_PURCHASE(range)

    Date, Shares, Proceeds
    _Custom Function to compute versus purchase gains (FIFO)._

    *Date* can be an actual date or id string (but rows of the range must be chronological).
    The passed range should contain exactly three coloumns of data (in chronological order
    to preserve first-in/first-out ordering of transactions). The three columns should contain:

    Shares is the number of shares purchased (if positive) or sold (if negative).
    - **Date** can be an actual date or id string (but rows of the range must be chronological).
    - **Shares** is the number of shares purchased (if positive) or sold (if negative).
    - **Proceeds** (in dollars) is the total received from sale (if positive) or paid to purchase (if negative).

    Proceeds (in dollars) is the total received from sale (if positive) or paid to purchase (if negative).

    The results of the function will fill in two columns for each sale:
    The results of the function will fill in two columns for each sale in the range:

    - **Basis** - Total amount paid for share sold.
    - **Versus** - List of purchases which this sale is paired with (displaying: shares@price (date))
  5. mckoss created this gist Apr 12, 2017.
    12 changes: 12 additions & 0 deletions vs_purchase-help.md
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,12 @@
    # VS_PURCHASE(range) - Custom Function to compute versus purchase gains (FIFO).

    Date, Shares, Proceeds

    *Date* can be an actual date or id string (but rows of the range must be chronological).

    Shares is the number of shares purchased (if positive) or sold (if negative).

    Proceeds (in dollars) is the total received from sale (if positive) or paid to purchase (if negative).

    The results of the function will fill in two columns for each sale: