Last active
April 12, 2017 17:41
-
-
Save mckoss/0971e8f818062e2b5dc41b7a33496c60 to your computer and use it in GitHub Desktop.
Revisions
-
mckoss revised this gist
Apr 12, 2017 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal 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). -
mckoss revised this gist
Apr 12, 2017 . 1 changed file with 3 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal 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)) See [Example Sheet](https://docs.google.com/spreadsheets/d/14zrdNfC9cea_2xsvMqcnl923z0mNErH1X97rmKNpQe0/edit#gid=0) -
mckoss revised this gist
Apr 12, 2017 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal 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 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). -
mckoss revised this gist
Apr 12, 2017 . 1 changed file with 10 additions and 7 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,12 +1,15 @@ # VS_PURCHASE(range) _Custom Function to compute versus purchase gains (FIFO)._ 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: - **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 in the range: - **Basis** - Total amount paid for share sold. - **Versus** - List of purchases which this sale is paired with (displaying: shares@price (date)) -
mckoss created this gist
Apr 12, 2017 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal 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: