Depending on applicable regulations or business limitations, specific API requests may not be available for your use.
Get All Closed Tax Lots
This request returns the information for all closed tax lots for an account.
Request URL
Syntax | GET /restapi/accounts/{accountnumber}/closedtaxlots?format=csv |
---|---|
Example URL | https://api.uat.foliofn.com/restapi/accounts/RA1234ABCD/closedtaxlots?format=csv |
Error Codes
See Get a Closed Tax Lot for the details of each error code.
Response Data Fields
See Get a Closed Tax Lot for the details of each field.
Response Example
Status Code: 200 OK
Content-Type: application/json
Date: Wed, 18 Dec 2013 18:47:57 GMT
Server: Sun GlassFish Enterprise Server v2.1.1
Transfer-Encoding: chunked
X-Powered-By: Servlet/2.5
[
[
{
"accountNumber": "RA1234ABCD",
"shareQuantity": "327.86902",
"salePrice": "9.640001",
"netSaleAmount": "3160.61",
"gainLossTerm": "SHORT_TERM",
"unadjustedShareQuantity": "327.86902",
"reportableGainLoss": "-839.39",
"saleDate": "2013-06-28T00:00:00.000-05:00",
"federalTaxWithholding": null,
"stateTaxWithholding": null,
"foreignTaxWithholding": null,
"withholdingCountry": null,
"withholdingState": null,
"covered": true,
"costBasisKnown": true,
"security": {
"ticker": "AAUKY",
"cusip": "03485P201",
},
"originatingTransactionId": "105235910",
"closingTransactionId": "110191035",
"adjustedCostBasis": "4000.00",
"origionalSharePrice": "12.19999",
"adjustedAcquisitionDate": "2013-05-10T00:00:00.000-05:00",
"disallowedLoss": "0.00",
"origionalAcquisitionDate": "2013-05-10T00:00:00.000-05:00",
"origionalCostBasis": "4000.00"
},
{
"accountNumber": "RA5471700Z",
"shareQuantity": "2.14000",
"salePrice": "25.560658",
"netSaleAmount": "54.70",
"gainLossTerm": "SHORT_TERM",
"unadjustedShareQuantity": "2.14000",
"reportableGainLoss": "-1.56",
"saleDate": "2011-06-15T00:00:00.000-05:00",
"federalTaxWithholding": null,
"stateTaxWithholding": null,
"foreignTaxWithholding": null,
"withholdingCountry": null,
"withholdingState": null,
"covered": true,
"costBasisKnown": true,
"security": {
"ticker": "ABB",
"cusip": "000375204",
},
"originatingTransactionId": "8758800",
"closingTransactionId": "8759163",
"adjustedCostBasis": "56.26",
"origionalSharePrice": "26.28972",
"adjustedAcquisitionDate": "2011-05-16T00:00:00.000-05:00",
"disallowedLoss": "0.00",
"origionalAcquisitionDate": "2011-05-16T00:00:00.000-05:00",
"origionalCostBasis": "56.26"
}
]
Response Example for CSV format
HTTP/1.1 200 OK
Date: Tue, 09 May 2017 18:19:27 GMT
Transfer-Encoding: chunked
Content-Type: application/tax-information
Content-Disposition: attachment;filename=RB18938005_closed_tax_lot.csv
Set-Cookie: JSESSIONID=QtHub_fmccHNTb6PZt3TcMA23Xke-Xt9RsPdBwUnIKRQwVuqB0lL!1942241555; path=/; secure; HttpOnly
Set-Cookie: _WL_AUTHCOOKIE_JSESSIONID=UNoyiJUtp1GUj-3XHJQt; path=/; secure; HttpOnly
Content-Language: en
Strict-Transport-Security: max-age=157680000
Symbol,Security,Quantity of Shares,Share Price,Total Purchase Price,Date Bought,Account Number,Status,Date Sold,Value per Share Sold,Total Proceeds,Reportable Gain/Loss,Disallowed Wash Sale,Covered,Original Cost,Original Acquisition Date
SLB,SCHLUMBERGER LTD,0.01472,91.71196,1.35,02/02/2015,RB18938005,ST,01/22/2016,63.39043,0.93,-0.42,0.00,Y,1.14,11/27/2015
SLB,SCHLUMBERGER LTD,0.00303,89.10891,0.27,02/16/2015,RB18938005,ST,01/22/2016,63.39043,0.19,-0.08,0.00,Y,0.20,01/11/2016
BCE,BCE INC,0.06922,40.73967,2.82,09/17/2015,RB18938005,ST,01/22/2016,38.86000,2.69,-0.13,0.00,Y,2.82,09/17/2015
G
Change Log
05/12/2017
- New query param 'format'.
02/22/2016
- Add error codes information.