One of the most important features of GoFiler is the ability to take Microsoft Office documents and turn them into EDGAR compliant documents that can be filed to the SEC. While conversion is easy to do manually in GoFiler, there is a function in Legato that can add a crucial step into an automated set of steps that can help make setting up filings a breeze. Today I will go in-depth on this function: ConvertFile.
Continue reading "LDC #136: Using Legato to Automate Document..." »Friday, May 17. 2019
LDC #136: Using Legato to Automate Document Conversion
Thursday, May 16. 2019
SEC Releases Draft 2019 DEI Taxonomy for EDGAR 19.2
The SEC has released the draft version of the 2019 DEI taxonomy for public review. This taxonomy contains the elements required for the tagging of cover page data for Inline XBRL submissions and is open for public comment until June 6, 2019.
Continue reading "SEC Releases Draft 2019 DEI Taxonomy for EDGAR..." »Tuesday, May 14. 2019
SEC Proposes Amendments to the Accelerated and Large Accelerated Filer Definitions
The SEC voted on May 9th to propose amendments to the accelerated filer and large accelerated filer definitions. These amendments would reduce costs for certain lower-revenue companies by more appropriately tailoring the types of companies that are categorized as accelerated and large accelerated filers while maintaining effective investor protections. Under these new amendments to Exchange Act Rule 12b-2, smaller reporting companies with less than $100 million in revenues would not be required to obtain an attestation of their internal control over financial reporting from an independent outside auditor. The key protections from the Sarbanes-Oxley Act of 2002, including independent audit committee requirements, CEO and CFO certifications of financial reports, and the requirement that companies continue to establish, maintain, and assess the effectiveness of their internal control, would not be altered by the proposed changes.
Continue reading "SEC Proposes Amendments to the Accelerated and..." »Friday, May 10. 2019
LDC #135: How To Automate Inserting Pictures into an HTML File
Whenever a task has to be done repeatedly and there’s not much thought that needs to go into running the task, it’s generally a great candidate for automating using a Legato script. I’ve been asked a few times in the past month or so how to quickly and easily insert multiple images into an HTML file. Since that’s a relatively easy task that just requires a lot of the same operation over and over again, I thought it would make a great example of automation for our Legato blog. So this week, we’ll take a look at a simple script that takes a folder as an input, scans it for images, and then inserts all of the images it finds into an HTML file.
Continue reading "LDC #135: How To Automate Inserting Pictures..." »Thursday, May 09. 2019
SEC Proposes to Improve Disclosures Relating to Acquisitions and Dispositions of Businesses
On May 3rd, the SEC proposed rule amendments to improve information that investors receive regarding the acquisition and disposition of businesses. The proposed amendments are also intended to facilitate more timely access to capital and reduce complexity and compliance costs.
Continue reading "SEC Proposes to Improve Disclosures Relating to..." »Friday, May 03. 2019
LDC #134: Using the Windows Registry
While Legato offers its own method of storing settings, sometimes a script will need to be able to read the settings of other applications. This includes applications that use the registry to store information. The Windows Registry is a database that is managed by the operating system that all applications, drivers, services, and other processes can use to store settings and other information. The registry was originally introduced as a common place for applications to store settings since INI files did not work well in a multi-user environment. With later versions of Windows, it became easier for applications to store INI or XML settings in a user’s profile, but some applications still use the registry as it offers some unique features. This week’s blog will be a discussion of the registry functions in Legato as well as some common pitfalls programmers may encounter when using the registry.
Continue reading "LDC #134: Using the Windows Registry" »Tuesday, April 30. 2019
SEC Staff Announces Agenda For May 31 FinTech Forum
On April 24th, the SEC announced the agenda for its May 31st forum that will discuss distributed ledger technology and assets. This conference, which is the 2019 FinTech Forum, will be held by the SEC’s Strategic Hub for Innovation and Financial Technology (FinHub) and will begin at 9:30 am EST in Washington, DC at the SEC’s Headquarters. It will be open to the public on a first-come, first-serve basis.
Continue reading "SEC Staff Announces Agenda For May 31 FinTech..." »Friday, April 26. 2019
LDC #133: Checkbox and Radio Button Controls Part Three
Automatic operation of checkbox and radio buttons is easy, but what if you want to extend the functionality or do something out of the ordinary? This blog discusses how to manage the control more closely via button notifications. I will also update the checkbox script from Part One of this series to use notifications to add a narrative description to the dialog.
Continue reading "LDC #133: Checkbox and Radio Button Controls..." »Friday, April 19. 2019
LDC #132: Adding Edit Functionality to the Page Break Manager
Last year, I wrote a series of blog posts on a Page Break Manager tool for GoFiler. It allowed users to save page breaks into a style template, rename them, and delete them. One feature was conspicuously absent though, the ability to edit a page break. Well, it seems like now would be a good time to rectify that mistake! This blog post is going to go over how to add the edit function to this script. It’s also a really good example of code should be written in a fairly modular fashion, because it makes it a lot easier to come back in and edit things later. I wrote this seven months ago, I don’t really remember how a lot of the functions work exactly. Things like reading the file into a data table, or saving the file back out, are somewhat complicated, and while I’m sure I could figure out how it’s working, there’s really no need to, since those are self-contained functions within the script. I don’t need to know how they work really, as long as they do what they’re supposed to do I can simply re-use them in this new function without a problem.
Continue reading "LDC #132: Adding Edit Functionality to the Page..." »
Friday, April 12. 2019
LDC #131: Building a Section 16 Data Scraper, Part 4: Dialog
It’s time to finish up our full script for our Section 16 data scraper. In the first three parts of this series we completed a base script that would go out to the SEC’s website, download all of the filings from a particular CIK, cache all of the Section 16 filings, find all of the reported transactions, put those transactions into a CSV file, and then read all of those transactions and figure out which of those transactions are current holdings. This week we are going to finish up by creating a dialog and adding our script functionality into the dialog.
Continue reading "LDC #131: Building a Section 16 Data Scraper,..." »
Friday, April 05. 2019
LDC #130: Synchronizing Meta Data
This week’s blog post is going to be an example of using Legato to analyze a directory and a csv file, and to update a database with the results. While this script is specialized for a personal website and may have a lot of practical application outside of similar websites, it showcases many of the concepts I want to cover in this blog and illustrates the ability of Legato to bring data together.
Continue reading "LDC #130: Synchronizing Meta Data" »Monday, April 01. 2019
SEC Releases EDGAR 19.1.1
On April 1, 2019, EDGAR Release 19.1.1 was released by the Securities and Exchange Commission. This release included a new “confidential” flag for NPORT-P and NPORT-NP filings as well as changes to the Dissemination Rule for N-PORT filings. Additionally, filers are now allowed submit NPORT-EX as an attachment to NPORT-P and NPORT-NP after August 31, 2019.
Continue reading "SEC Releases EDGAR 19.1.1" »Friday, March 29. 2019
New Release (4.26b) for the GoFiler Family of Products
Version 4.26b of all applications in the GoFiler Suite has been released. This release corresponds to EDGAR Release 19.1.1 and contains a number of improvements to Form N-CEN View and Form N-PORT View. Additionally, this version contains new functions for XDX, support for the XBRL Previewer for EDGAR 19.1.1, and improvements to some general EDGAR tools.
Continue reading "New Release (4.26b) for the GoFiler Family of..." »LDC #129: Building a Section 16 Data Scraper, Part 3: Analysis
It’s time to finish up our base script for our Section 16 data scraper. In the first two parts of this series we started a script that would go out to the SEC’s website, download all of the filings from a particular CIK, cache all of the Section 16 filings, find all of the reported transactions, and put those transactions into a CSV file. This week we are going to finish up the base functionality by reading through all of the transactions and finding the current holdings. Additionally we are going to perform a large amount of refactoring as well as add in the functionality to look at reported holdings.
Continue reading "LDC #129: Building a Section 16 Data Scraper,..." »
Thursday, March 28. 2019
SEC Proposes Offering Reforms for Business Development Companies and Registered Closed-End Funds
Quicksearch
Categories
Calendar
![]() |
May '25 |
![]() |
||||
---|---|---|---|---|---|---|
Mo | Tu | We | Th | Fr | Sa | Su |
Friday, May 02. 2025 | ||||||
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |