Perform various data analysis on SEC 13-F and obtain some insights of fund activities such as number of holdings, AUM, and change of holdings between two quarters.
日本語の概要は準備中です。原文の説明を表示しています。
Reference for the EBCDIC "overpunch" / zoned-decimal sign convention where the units position of a numeric field is replaced with a letter that encodes both a digit and a sign. Useful when reading mainframe-style fixed-length tapes whose amount fields appear as digits followed by a letter (e.g. "0000000000123D" or "0000000000045M").
インストール方法を見るインストールする前に、エージェントに与えられる指示の中身を確認できます。
On classic mainframe tapes, signed numeric amounts are stored as N-1 digits followed by a single byte where the high-order bits carry the sign and the low-order bits carry the final decimal digit. When the file is converted to ASCII / printable form, the last byte is rendered as a letter (or a brace).
| Char | Sign | Last digit | Char | Sign | Last digit | |
|---|---|---|---|---|---|---|
{ | + | 0 | } | − | 0 | |
A | + | 1 | J | − | 1 | |
B | + | 2 | K | − | 2 | |
C | + | 3 | L | − | 3 | |
D | + | 4 | M | − | 4 | |
E | + | 5 | N | − | 5 | |
F | + | 6 | O | − | 6 | |
G | + | 7 | P | − | 7 | |
H | + | 8 | Q | − | 8 | |
I | + | 9 | R | − | 9 |
Positive zero is {; negative zero is }. Both decode to magnitude 0 — keep
the sign attached so downstream arithmetic doesn't drop a debit's polarity.
The positive half of the table ({, A–I) is the visible-looking case and
is often handled first. The negative half (}, J–R) looks like ordinary
letters and is easy to forget. If only the positive letters are decoded,
debits and credits both come through as positive — the totals look plausible
but signs are wrong on every negative row.
Split the field into the leading digits and the overpunch byte, look up the sign + units digit from the table above, recombine, then build the signed working-storage value. The shape below uses generic identifiers — substitute your own field names:
*> placeholders: digits-buf holds the recombined unsigned digits,
*> op-char is the overpunch byte, sgn / lo-digit are scratch.
split raw-amount into (leading-digits, op-char)
EVALUATE op-char
WHEN "{" sgn := "+" lo-digit := 0 *> positive zero
WHEN "A" THRU "I" sgn := "+" lo-digit := 1..9
WHEN "}" sgn := "-" lo-digit := 0 *> negative zero
WHEN "J" THRU "R" sgn := "-" lo-digit := 1..9
END-EVALUATE
digits-buf := leading-digits with lo-digit appended
signed-value := (sgn = "-") ? -digits-buf : +digits-buf
The decisive point is that the EVALUATE must cover both halves of the
table — the negative letters } and J–R as well as the positive
{/A–I. The exact PIC clauses and MOVE targets depend on your own
record layout; what matters is that no overpunch character falls through
undecoded.
Some shops use COBOL's SIGN IS TRAILING SEPARATE / SIGN IS TRAILING
clauses with native EBCDIC zoned data, but on ASCII-converted tapes the
characters above are literally what you read — explicit lookup is the
clearest decode.
Pick one positive and one negative row from the tape, decode by hand using the table, and reconcile against an expected total. If only the positive side works you will see plausible magnitudes but inverted aggregate signs.
SIGN IS … clauses.{ A B C D E F G H I and negative } J K L M N O P Q R).まだレビューはありません。使ってみた感想をお寄せください。
概要と使いどころ
Perform various data analysis on SEC 13-F and obtain some insights of fund activities such as number of holdings, AUM, and change of holdings between two quarters.
日本語の概要は準備中です。原文の説明を表示しています。
AC branch pi-model power flow equations (P/Q and |S|) with transformer tap ratio and phase shift, matching `acopf-math-model.md` and MATPOWER branch fields. Use when computing branch flows in either direction, aggregating bus injections for nodal balance, checking MVA (rateA) limits, computing branch loading %, or debugging sign/units issues in AC power flow.
日本語の概要は準備中です。原文の説明を表示しています。
Redact text from PDF documents for blind review anonymization
日本語の概要は準備中です。原文の説明を表示しています。
Use when checking simplified ADA-derived plan-view bathroom accessibility constraints such as turning space, door clear width, toilet centerline, grab bars, and lavatory knee/toe clearance.
日本語の概要は準備中です。原文の説明を表示しています。
Analyze failed GitHub Action jobs for a pull request.
日本語の概要は準備中です。原文の説明を表示しています。
Use when extracting plan-view architectural geometry from DXF files with semantic CAD layers, especially when outputs must normalize rooms, doors, fixtures, clearances, and grab bars into machine-checkable JSON.
日本語の概要は準備中です。原文の説明を表示しています。