If you have ever wanted to format data from a database into a web format then you have experienced the added difficulty of working with HTML. For this week’s blog we are going to be taking a look at Legato’s HTML Writer object. This object allows us to create HTML coding with very little knowledge of HTML but allows us access to some advanced features of HTML like CSS. In order to show the HTML Writer object, we will convert a CSV file to HTML but the data source could easily be adapted to any file format or database.
Continue reading "LDC #124: Converting CSV to HTML using Legato" »Friday, February 22. 2019
LDC #124: Converting CSV to HTML using Legato
Friday, February 15. 2019
LDC #123: Comparing Two Zip Files
Many times we developers download tools and updates to specifications in zip files. Figuring out which files have changed between versions can be a pain. For this blog, we are going to create a simple script to help compare the contents of two different zip files. Instead of having to check all the files, you can run this script and have it print a list of the files that need to be reviewed.
Continue reading "LDC #123: Comparing Two Zip Files" »Friday, February 08. 2019
LDC #122: Building a Section 16 Data Scraper, Part 2: Aggregation
A few weeks ago we started building a Section 16 Data Scraper with the intention of a user being able to enter a CIK and Legato downloading all of the CIK’s Section 16 filings, putting the data together into a spreadsheet, and then being able to start a Section 16 filing by using that data as an entry point. At the end of the last post we had a script that would go out and download all of a singular CIK’s filings. It would also cache any filings it saw so that we were only downloading each individual filing once. This week we are going to continue onward and code a system to scrape useful data out of the filings and put it together into a CSV file.
Continue reading "LDC #122: Building a Section 16 Data Scraper,..." »Friday, February 01. 2019
LDC #121: An Introduction to the EDGAR Data Access Class
In our recent blog series discussing Bulk Filings, we used a couple of functions to open and save files, EDACOpenFile and EDACSaveFile. EDAC, or the EDGAR Data Access Class, is a method to interact with EDGAR submission files (as defined by the SEC’s EDGAR Form XML specifications) using Legato. We used EDAC functions to open the submission files and to save them, but EDAC is much more powerful than that. In fact, using the EDAC functions to open and save files is like using a chainsaw to trim a finger nail.
Continue reading "LDC #121: An Introduction to the EDGAR Data..." »
(Page 1 of 1, totaling 4 entries)
