Friday, May 20. 2022
Friday, January 14. 2022
As a reminder, the SEC is updating the ciphers it supports in its Transport Layer Security (TLS) cryptographic protocol on Monday, January 17, 2022. The upcoming upgrade was previously announced on August 25, 2021 and October 27, 2021.Continue reading "SEC Revises Notification for EDGAR Cipher Update" »
Tuesday, June 16. 2020
One common request I get from clients is that they want to add dot leaders to some kinds of tables. Dot leaders are pretty common and also look great in documents but are also deceptively difficult to do in HTML. With regular typesetting software, you can fill white space with periods or other characters using a variety of methods that are relatively easy to employ. Typeset documents have set widths and fonts that don’t vary depending on external factors. HTML, on the other hand, is highly dependent on a user’s viewport settings.
Continue reading "LDC #170: Adding Dot Fill Leaders With Embedded..." »
Friday, April 24. 2020
Back in 2017, I wrote a post about a script that would align outline text, which would insert spacers into a formatted outline document to make it consistently spaced. This script has been in use for a few years by a few readers of this blog, and it generally works pretty well, but earlier this week I got a question about it. If a document is otherwise nicely formatted, and you only want to align a section of the document, running the script on an entire document is probably a bad idea, because there is always the possibility of it changing something that already looks pretty good. The question, then, was asking if it was possible to modify this script to run on a portion of the document, instead of the whole document.
Continue reading "LDC #169: Adding New Functionality To Older..." »
Monday, March 16. 2020
Friday, February 28. 2020
Last month I described a tool I built to create and insert web news links in my blog, “A Quick Web Link Builder”. I recently expanded the functionality to load the web page and extract information to load link information into the dialog, thus making linking an even quicker process.
Continue reading "LDC #167: A Quick Web Link Builder Part II" »
Friday, February 07. 2020
This week, we’re taking a look at automating the subject company lookup on SC13D/G filings. This is another request from a client, but I think it provides a good opportunity to look at automation of a pretty simple task that otherwise might be forgotten and overlooked by a busy operator. This script will trigger when a user opens a project file (a .GFP file), if and only if the project being opened is of document type SC 13D or SC 13G. These are the best kinds of tasks to automate, because they are specific, and easily forgotten by an operator. If the document opened meets these criteria, the CIK of the subject company will be looked up, and the name of the subject company will be looked up on the EDGAR system and entered into the name field. This is very useful if you have an automated system that is creating .GFP files (not very hard, it’s a pretty simple file format), but you cannot guarantee that system has access to the most current names of companies. For example, if the system generating the GFP files has an outdated database of names, you would want to make sure that the subject company is replaced with current information on file open. This is where our script comes in.
Continue reading "LDC #166: Forcing a Subject Company Name Lookup..." »
Friday, January 24. 2020
While the Novaworks tools are principally used for EDGAR, sometimes there are non-EDGAR things to do. One of my activities is maintaining a website for a not-for-profit group supporting amateur radio. As part of my duties, the front page of the site has a section on recent non-club news which requires me to perform a little research and then add the links to the page. This script helps reduce the time to create the links.Continue reading "LDC #165: A Quick Web Link Builder" »
Friday, January 10. 2020
This week, we’re taking another look at using Legato to enhance GoFiler’s validation. Last month, someone asked me if there was a way GoFiler could check a 10-Q project to ensure a completed XBRL file set was attached to it. Well, this isn’t something GoFiler normally checks for (since there are times when you might want to omit these files), but we can definitely use Legato to enhance the validation of the project file, so we can warn the user if they might have forgotten something. It also gives us another opportunity to demonstrate some of the project file functions, which are always useful if you’re going to be working with GFP files.
Continue reading "LDC #164: Validating Project Files Have XBRL" »
Friday, December 27. 2019
For this week’s blog post we are going to discuss tracking elapsed time in Legato. Like many things in Legato, there are a number of different ways to accomplish this task, each with their pros and cons. Many of these functions have appeared in other scripts we’ve previously posted but this article will be a more in-depth look at these functions.Continue reading "LDC #163: Tracking Time in Legato" »
Monday, December 16. 2019
Everyone has their favorite quick keys. It you have been working in MS Word for a long time, you are probably used to pressing Ctrl+E or Ctrl+R to center or right align text. In GoFiler, the corresponding keys are F6 and F8, respectively. But what if you want to change the quick keys in GoFiler? In this blog, I will begin to explore quick keys and the foundation of how GoFiler processes them. The next blog will explain how Legato can be used to modify quick keys. In the end, you as a Legato programmer should understand how to use and alter quick keys to best suit your own particular needs.
Continue reading "LDC #162: An Introduction to Quick Keys" »
Monday, November 25. 2019
In the EDGAR world, inline CSS can be used to style documents. However, CSS style sheets are not allowed. I recently ran into a case where document needed to be published on a system which was just the opposite — CSS classes are ok, but inline styles are verboten. A quick Legato script saved may hours of work by translating the inline styles to a style sheet.Continue reading "LDC #161: Quickly Adding CSS Classes to an..." »
Friday, November 22. 2019
On November 19th, XBRL US released the Taxonomy Development Handbook for public review. The handbook is a comprehensive guide that directs regulators, industry experts, and businesses through a practical roadmap to building high quality data standards with XBRL. This freely available, foundational document takes readers through the necessary stages of standards development, including: 1) building the appropriate transport data model, 2) assessing project scope, including use cases and requirements, 3) establishing a governance structure, 4) documenting the standards program, and 5) the step-by-step mechanics of building the taxonomy. The handbook also contains an introduction to the XBRL financial data standard, templates to guide developers in documenting the taxonomy, and case studies of XBRL as a method of improving data reporting in various industries.Continue reading "XBRL US Releases Taxonomy Development Handbook..." »
Friday, November 15. 2019
Last month, we discussed logging user submissions to the SEC in our blog post LDC 154. Well, thinking more about this, I realized it was probably not a good idea to not secure the log file. If someone makes a mistake, and files a document they shouldn’t, they could simply alter the log to show different times or users filing the document, and there is no record of it. A malicious user could easily just change what the log says! This is unacceptable and easily within our power to fix. To do so, we’re going to use a common function, the MD5 hash function.
Continue reading "LDC #160: Securing Log Files with MD5" »
Friday, November 01. 2019
I had an interesting issue crop up this week: a client had a file that had a 21 inch indent on a paragraph, causing problems when the file was printed to PDF. When GoFiler converts your Word file to HTML, if there are a lot of spaces or tabs on a line, it can cause GoFiler to interpret it as having a large indent level. Normally this isn’t a big deal, but if the indent ends up as large as this, it can cause rendering issues. So, I was asked if there was a way we could test for this, and figured it would be an interesting problem for a blog post.
Continue reading "LDC #159:Validating HTML Indents and Margins..." »