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

  1. New query param 'format'.

02/22/2016

  1. Add error codes information.

Getting Started

REST APIs

Resources

Developer Home