Company API
API change historyA collection of RESTful methods that returns various financial data for a requested company including balance sheets, stock quotes , company look-up utilities and more.
Balance Sheet
Returns a company's most recent balance sheet summarizing their liabilities, assets and shareholders' equity.
Try itRequest
Request URL
Request parameters
-
string
Publicly traded company's stock symbol
-
(optional)string
Annual (10-K) or Quarterly (10-Q)
-
(optional)number
Retrieve an older financial statement by specifying number of filings to go back. For example, to retrieve the second to most recent filing, specify a filingOrder value of 1. By default, the most recent filing is returned (filingOrder = 0)
Request headers
Request body
Responses
200 OK
Financial statement found. Keys in result element varies per company and year of filing based on US GAAP Financial Reporting Taxonomy
Representations
{
"meta": {
"copyright": "Copyright 2020 Last10K.com All Rights Reserverd",
"terms": "https://dev.last10k.com/terms"
},
"data": {
"attributes": {
"status": 0,
"company": {
"name": "MICROSOFT CORP",
"cik": "789019",
"ticker": "msft"
},
"filing": {
"name": "Balance Sheets",
"accessionNumber": "0001564590-19-027952",
"filingDate": "2019-08-01T00:00:00",
"period": "2019-06-30T00:00:00",
"source": "10-K",
"filingCount": 16
},
"count": 33,
"result": {
"CashAndCashEquivalentsAtCarryingValue": 11356000000,
"ShortTermInvestments": 122463000000,
"CashCashEquivalentsAndShortTermInvestments": 133819000000,
"AccountsReceivableNetCurrent": 29524000000,
"InventoryNet": 2063000000,
"OtherAssetsCurrent": 10146000000,
"AssetsCurrent": 175552000000,
"PropertyPlantAndEquipmentNet": 36477000000,
"OperatingLeaseRightOfUseAsset": 7379000000,
"LongTermInvestments": 2649000000,
"Goodwill": 42026000000,
"FiniteLivedIntangibleAssetsNet": 7750000000,
"OtherAssetsNoncurrent": 14723000000,
"Assets": 286556000000,
"AccountsPayableCurrent": 9382000000,
"LongTermDebtCurrent": 5516000000,
"EmployeeRelatedLiabilitiesCurrent": 6830000000,
"AccruedIncomeTaxesCurrent": 5665000000,
"ContractWithCustomerLiabilityCurrent": 32676000000,
"OtherLiabilitiesCurrent": 9351000000,
"LiabilitiesCurrent": 69420000000,
"LongTermDebtNoncurrent": 66662000000,
"AccruedIncomeTaxesNoncurrent": 29612000000,
"ContractWithCustomerLiabilityNoncurrent": 4530000000,
"DeferredTaxLiabilitiesNoncurrent": 233000000,
"OperatingLeaseLiabilityNoncurrent": 6188000000,
"OtherLiabilitiesNoncurrent": 7581000000,
"Liabilities": 184226000000,
"CommonStocksIncludingAdditionalPaidInCapital": 78520000000,
"RetainedEarningsAccumulatedDeficit": 24150000000,
"AccumulatedOtherComprehensiveIncomeLossNetOfTax": -340000000,
"StockholdersEquity": 102330000000,
"LiabilitiesAndStockholdersEquity": 286556000000
}
},
"type": "statement",
"id": "d58ae67c-b687-455d-bcfc-7863e982a416"
}
}404 Not Found
Company does not have a financial statement of this type
Code samples
@ECHO OFF
curl -v -X GET "https://services.last10k.com/v1/company/{ticker}/balancesheet?formType=10-K&filingOrder=0"
-H "Ocp-Apim-Subscription-Key: {subscription key}"
--data-ascii "{body}"
using System;
using System.Net.Http.Headers;
using System.Text;
using System.Net.Http;
using System.Web;
namespace CSHttpClientSample
{
static class Program
{
static void Main()
{
MakeRequest();
Console.WriteLine("Hit ENTER to exit...");
Console.ReadLine();
}
static async void MakeRequest()
{
var client = new HttpClient();
var queryString = HttpUtility.ParseQueryString(string.Empty);
// Request headers
client.DefaultRequestHeaders.Add("Ocp-Apim-Subscription-Key", "{subscription key}");
// Request parameters
queryString["formType"] = "10-K";
queryString["filingOrder"] = "0";
var uri = "https://services.last10k.com/v1/company/{ticker}/balancesheet?" + queryString;
var response = await client.GetAsync(uri);
}
}
} // // This sample uses the Apache HTTP client from HTTP Components (http://hc.apache.org/httpcomponents-client-ga/)
import java.net.URI;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.utils.URIBuilder;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.util.EntityUtils;
public class JavaSample
{
public static void main(String[] args)
{
HttpClient httpclient = HttpClients.createDefault();
try
{
URIBuilder builder = new URIBuilder("https://services.last10k.com/v1/company/{ticker}/balancesheet");
builder.setParameter("formType", "10-K");
builder.setParameter("filingOrder", "0");
URI uri = builder.build();
HttpGet request = new HttpGet(uri);
request.setHeader("Ocp-Apim-Subscription-Key", "{subscription key}");
// Request body
StringEntity reqEntity = new StringEntity("{body}");
request.setEntity(reqEntity);
HttpResponse response = httpclient.execute(request);
HttpEntity entity = response.getEntity();
if (entity != null)
{
System.out.println(EntityUtils.toString(entity));
}
}
catch (Exception e)
{
System.out.println(e.getMessage());
}
}
}
<!DOCTYPE html>
<html>
<head>
<title>JSSample</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script>
</head>
<body>
<script type="text/javascript">
$(function() {
var params = {
// Request parameters
"formType": "10-K",
"filingOrder": "0",
};
$.ajax({
url: "https://services.last10k.com/v1/company/{ticker}/balancesheet?" + $.param(params),
beforeSend: function(xhrObj){
// Request headers
xhrObj.setRequestHeader("Ocp-Apim-Subscription-Key","{subscription key}");
},
type: "GET",
// Request body
data: "{body}",
})
.done(function(data) {
alert("success");
})
.fail(function() {
alert("error");
});
});
</script>
</body>
</html>
#import <Foundation/Foundation.h>
int main(int argc, const char * argv[])
{
NSAutoreleasePool * pool = [[NSAutoreleasePool alloc] init];
NSString* path = @"https://services.last10k.com/v1/company/{ticker}/balancesheet";
NSArray* array = @[
// Request parameters
@"entities=true",
@"formType=10-K",
@"filingOrder=0",
];
NSString* string = [array componentsJoinedByString:@"&"];
path = [path stringByAppendingFormat:@"?%@", string];
NSLog(@"%@", path);
NSMutableURLRequest* _request = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:path]];
[_request setHTTPMethod:@"GET"];
// Request headers
[_request setValue:@"{subscription key}" forHTTPHeaderField:@"Ocp-Apim-Subscription-Key"];
// Request body
[_request setHTTPBody:[@"{body}" dataUsingEncoding:NSUTF8StringEncoding]];
NSURLResponse *response = nil;
NSError *error = nil;
NSData* _connectionData = [NSURLConnection sendSynchronousRequest:_request returningResponse:&response error:&error];
if (nil != error)
{
NSLog(@"Error: %@", error);
}
else
{
NSError* error = nil;
NSMutableDictionary* json = nil;
NSString* dataString = [[NSString alloc] initWithData:_connectionData encoding:NSUTF8StringEncoding];
NSLog(@"%@", dataString);
if (nil != _connectionData)
{
json = [NSJSONSerialization JSONObjectWithData:_connectionData options:NSJSONReadingMutableContainers error:&error];
}
if (error || !json)
{
NSLog(@"Could not parse loaded json with error:%@", error);
}
NSLog(@"%@", json);
_connectionData = nil;
}
[pool drain];
return 0;
}
<?php
// This sample uses the Apache HTTP client from HTTP Components (http://hc.apache.org/httpcomponents-client-ga/)
require_once 'HTTP/Request2.php';
$request = new Http_Request2('https://services.last10k.com/v1/company/{ticker}/balancesheet');
$url = $request->getUrl();
$headers = array(
// Request headers
'Ocp-Apim-Subscription-Key' => '{subscription key}',
);
$request->setHeader($headers);
$parameters = array(
// Request parameters
'formType' => '10-K',
'filingOrder' => '0',
);
$url->setQueryVariables($parameters);
$request->setMethod(HTTP_Request2::METHOD_GET);
// Request body
$request->setBody("{body}");
try
{
$response = $request->send();
echo $response->getBody();
}
catch (HttpException $ex)
{
echo $ex;
}
?>########### Python 2.7 #############
import httplib, urllib, base64
headers = {
# Request headers
'Ocp-Apim-Subscription-Key': '{subscription key}',
}
params = urllib.urlencode({
# Request parameters
'formType': '10-K',
'filingOrder': '0',
})
try:
conn = httplib.HTTPSConnection('services.last10k.com')
conn.request("GET", "/v1/company/{ticker}/balancesheet?%s" % params, "{body}", headers)
response = conn.getresponse()
data = response.read()
print(data)
conn.close()
except Exception as e:
print("[Errno {0}] {1}".format(e.errno, e.strerror))
####################################
########### Python 3.2 #############
import http.client, urllib.request, urllib.parse, urllib.error, base64
headers = {
# Request headers
'Ocp-Apim-Subscription-Key': '{subscription key}',
}
params = urllib.parse.urlencode({
# Request parameters
'formType': '10-K',
'filingOrder': '0',
})
try:
conn = http.client.HTTPSConnection('services.last10k.com')
conn.request("GET", "/v1/company/{ticker}/balancesheet?%s" % params, "{body}", headers)
response = conn.getresponse()
data = response.read()
print(data)
conn.close()
except Exception as e:
print("[Errno {0}] {1}".format(e.errno, e.strerror))
####################################require 'net/http'
uri = URI('https://services.last10k.com/v1/company/{ticker}/balancesheet')
query = URI.encode_www_form({
# Request parameters
'formType' => '10-K',
'filingOrder' => '0'
})
if uri.query && uri.query.length > 0
uri.query += '&' + query
else
uri.query = query
end
request = Net::HTTP::Get.new(uri.request_uri)
# Request headers
request['Ocp-Apim-Subscription-Key'] = '{subscription key}'
# Request body
request.body = "{body}"
response = Net::HTTP.start(uri.host, uri.port, :use_ssl => uri.scheme == 'https') do |http|
http.request(request)
end
puts response.body