Row 1549

Row ID: 1549 | Dataset Entry | Axioma AXP Content Repository

Content Data

This page contains data entry 1549 from the Axioma AXP content repository. The structured data below represents the complete record for this entry.

Hi all. I am trying to match Dealscan data on loans and Compustat data on companies.

I am using the "new" version of Dealscan (not Dealscan Legacy), and thus have to generate a facility id to be able to merge it later with Compustat. I have been able to do so successfully. However, when using [Chava & Roberts linking table](https://finance.wharton.upenn.edu/~mrrobert/styled-9/styled-12/index.html) (How does Financing Impact Investment? The Role of Debt Covenants," with Sudheer Chava, Journal of Finance 2008, 63, 2085 - 2121.), I do not have any common facility id in that table and in my Dealscan data. Problem is that in Chava and Robert's table, the largest facility id is 385433, and in my Dealscan data all of them are **greater** than 385433. Do you know if there is any other table I might use for the linking?

Thanks.

FieldValue
text Hi all. I am trying to match Dealscan data on loans and Compustat data on companies. I am using the "new" version of Dealscan (not Dealscan Legacy), and thus have to generate a facility id to be able to merge it later with Compustat. I have been able to do so successfully. However, when using [Chava & Roberts linking table](https://finance.wharton.upenn.edu/~mrrobert/styled-9/styled-12/index.html) (How does Financing Impact Investment? The Role of Debt Covenants," with Sudheer Chava, Journal of…
label r/econpapers
dataType post
communityName r/EconPapers
datetime 2022-12-07
username_encoded Z0FBQUFBQm5Lakwwa0xNa0ZtTFlBWWRsZnJsY0NXeXp5OEpCVXBhRDN4UlQwVk5XMUN5U0hwSng1QmZWV3pQTWpDWFY2ckVEYXVGcGhKRmpuQ1MtdGtUV2xpZ2dHN3ktZ0E9PQ==
url_encoded Z0FBQUFBQm5Lak9EV3VQOHJfcXB4SmVoMWRSWnZQU1dsYjRRUkJyeTgwWHFEMmZId1ZlUzM1SkYtTS1QQUxLaDU2UGxJbWlCcWdBQUwtTmhaVFZxb2ZRdmdJWF9iaElTT2ZKaHQzXzNtZktXT3JYSy1MMzdqRUVOTDQ2MGQtRmt1WThMVmdMei1LTUxHNm1HVTdOekc4eGNhVVNCQ3c4SFNwVmV2aHpfRzBSTmQtajA4dS1WQXVtejBWcFBBdl9Lc2g5TjYtWGpBeHNP

Raw Record

{
  "text": "Hi all. I am trying to match Dealscan data on loans and Compustat data on companies.\n\nI am using the \"new\" version of Dealscan (not Dealscan Legacy), and thus have to generate a facility id to be able to merge it later with Compustat. I have been able to do so successfully. However, when using [Chava & Roberts linking table](https://finance.wharton.upenn.edu/~mrrobert/styled-9/styled-12/index.html) (How does Financing Impact Investment? The Role of Debt Covenants,\" with Sudheer Chava, Journal of Finance 2008, 63, 2085 - 2121.), I do not have any common facility id in that table and in my Dealscan data. Problem is that in Chava and Robert's table, the largest facility id is 385433, and in my Dealscan data all of them are **greater** than 385433. Do you know if there is any other table I might use for the linking?\n\nThanks.",
  "label": "r/econpapers",
  "dataType": "post",
  "communityName": "r/EconPapers",
  "datetime": "2022-12-07",
  "username_encoded": "Z0FBQUFBQm5Lakwwa0xNa0ZtTFlBWWRsZnJsY0NXeXp5OEpCVXBhRDN4UlQwVk5XMUN5U0hwSng1QmZWV3pQTWpDWFY2ckVEYXVGcGhKRmpuQ1MtdGtUV2xpZ2dHN3ktZ0E9PQ==",
  "url_encoded": "Z0FBQUFBQm5Lak9EV3VQOHJfcXB4SmVoMWRSWnZQU1dsYjRRUkJyeTgwWHFEMmZId1ZlUzM1SkYtTS1QQUxLaDU2UGxJbWlCcWdBQUwtTmhaVFZxb2ZRdmdJWF9iaElTT2ZKaHQzXzNtZktXT3JYSy1MMzdqRUVOTDQ2MGQtRmt1WThMVmdMei1LTUxHNm1HVTdOekc4eGNhVVNCQ3c4SFNwVmV2aHpfRzBSTmQtajA4dS1WQXVtejBWcFBBdl9Lc2g5TjYtWGpBeHNP"
}
Explore Dataset Explore Row

Entry Information