<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Alexander Falk on Medium]]></title>
        <description><![CDATA[Stories by Alexander Falk on Medium]]></description>
        <link>https://medium.com/@afalk?source=rss-98e069f1a47e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*CBPc5tii-e7occXQ.jpg</url>
            <title>Stories by Alexander Falk on Medium</title>
            <link>https://medium.com/@afalk?source=rss-98e069f1a47e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 20:34:26 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@afalk/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Learn a New Programming Language this Summer]]></title>
            <link>https://medium.com/@afalk/learn-a-new-programming-language-this-summer-65ada83825bf?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/65ada83825bf</guid>
            <category><![CDATA[programming-languages]]></category>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[c]]></category>
            <category><![CDATA[programming]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Tue, 31 May 2016 19:29:02 GMT</pubDate>
            <atom:updated>2016-06-12T12:14:45.476Z</atom:updated>
            <content:encoded><![CDATA[<p>What better goal to set for your summer than learning a new programming language? Forget the “beach books” this summer and set your sights on diving into a new coding language — but which one should you pick?</p><p>As reported by <a href="http://cdn.infoq.com/statics_s1_20151006-0049u2/resource/news/2014/01/IDC-software-developers/en/resources/IDC-2014-ITC-estimates-2.png">IDC</a> there are approximately 11 million professional software developers on Earth, and around 690 notable programming languages (according to <a href="https://en.wikipedia.org/wiki/List_of_programming_languages">Wikipedia</a>). I would wager a bet there is a staggeringly equal number of places online where you can learn one programming language or another. Whether you are already one of those 11 million coding experts or a newbie to programming, there is a plethora of information out there to sort though.</p><p>For the purposes for this blog post, we will certainly look at the world’s most-widely-used programming languages in 2016 (see <a href="http://spectrum.ieee.org/computing/software/the-2015-top-ten-programming-languages">this IEEE article</a>), but also at important languages for data manipulation and querying, so we’ll discuss: C and its derivatives (C++, C#, and Objective-C), Java, Python, R, JavaScript, Ruby, SQL, and XQuery.</p><p>Deciding where to start depends entirely on the kind of development scenarios you have in mind, so we’ve broken things down for you to make it easier. It doesn’t matter if you are a seasoned programmer looking to add a new language to your repertoire or a novice who doesn’t know the difference between C, C++, Objective-C, or C# yet. We have assembled a list of explanations to help you choose which language you may want to conquer next.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*qMWzxfWiz_uWBfVAh34x5A.png" /></figure><p>Before we get down into the weeds and look at each language in detail, let’s talk about the six main areas where programming languages are employed today and what languages might be useful in which context. This will give you a roadmap and some early sense of which language might be the most appropriate one to learn for you.</p><p><strong>Mobile Apps</strong>: when you want to develop apps for smartphones or tablets, your choice of language is largely dictated by the platform you want to develop for. If you want to target iOS devices, the standard language is Objective-C, when you develop for Android the default language is Java, and for Windows Phone it is C#. And if your mobile app requires a server back-end running in the cloud, see the paragraph on server-side development below for additional languages. If you want to target all three mobile platforms and that sounds like a little bit too much to learn all at once, I recommend looking into cross-platform tools such as <a href="http://www.altova.com/mobiletogether.html">Altova MobileTogether</a> that allow you to build one mobile app for all platforms from one source using XQuery and visual ActionTree scripting.</p><p><strong>Web Development</strong>: for developing websites both for the mobile web and classic desktop-based browsers, the programming language of choice that will be executed by the web-browser is JavaScript. Sure, the main content of your website will be written in HTML5 and hopefully all of your style information will be encoded into CSS3 style sheets, but those are not programming languages per se. And so far I’ve only talked about the client-side programming.</p><p><strong>Server-side Development</strong>: no matter if you’re talking about the back-end of a mobile app or a classic web-server, there are a whole bunch of different programming languages that are good for server-side development. This is where you’ll find Java, C#, Python, PHP, and Ruby being used the most. And this is true for both old-school hosted web servers as well as cloud-based servers that may be running on the AWS or Azure cloud platform.</p><p><strong>Classic PC/Desktop Applications</strong>: while Java and Visual Basic applications are sometimes used in enterprise environments, the majority of PC-based desktop applications have been and are still being developed in C, C++, or C#. However, languages such as Python are gaining popularity even on the desktop as a scripting language for automating common tasks.</p><p><strong>Scientific Computing</strong>: for data analysis, statistics, and higher math there are three special-purpose languages that are commonly used: Matlab, Mathematica, and R. Based on the popularity alone, R has simply outpaced the other two over the last several years, so I’ll just discuss R below.</p><p><strong>Embedded Devices &amp; IoT</strong>: when it comes to embedded devices, C and C++ are still king. This field has certainly been in flux over the last few years, as more and more embedded and IoT devices end up being fully-fledged Linux computers, but for software development that’s very close to the hardware layer, as well as for many operating-system functions and device drivers, the power, speed, and efficiency of C still make it the top choice for this field.</p><p><strong>Database Queries and Data Manipulation</strong>: irrespective of which of the above areas you have in mind, you will almost always need to also know a language that lets you query a subset of some data collection from a database. While Hadoop/MapReduce, and other big-data focused platforms get all the hype in the news today, SQL — the Structured Query Language — has been around since the 70s and is still the most widely used database query language, being supported by all major database systems.</p><p>In addition to SQL, I would also recommend taking a good look at XQuery, the XML Query language, because a lot of data is accessible in XML or JSON nowadays, and XQuery is very powerful as a functional language in manipulating such data efficiently. In particular, advanced mobile tools such as <a href="http://www.altova.com/mobiletogether.html">Altova MobileTogether </a>use XQuery to allow functional programming of data manipulation from a <a href="http://www.altova.com/mobiletogether/sources.html">variety of data sources</a>, including XML, JSON, HTML, and SQL databases.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*lKTzy1fRzhUeGSKd25liXQ.png" /></figure><p>Now that I’ve given you an overview of where some of these languages are most often used, you hopefully have an idea of which language might be a suitable candidate for you to learn next. So let’s talk about the individual languages in detail now and where you can learn them online:</p><p><strong>C</strong> and its derivatives (C++, C#, and Objective-C) are general purpose programming languages and C has been widely popular since the seminal 1978 book <em>The C Programming Language</em> by Kernighan and Ritchie. If you are serious about a career in computer science, knowledge of C is still a must, but I would not recommend it as a wise choice to start with for beginners, as it is most commonly used for work on hardware-related or other lower-level applications. C was originally built to use on the UNIX operating system and is today most often used for implementing operating systems, device drivers, and embedded applications.</p><p>Places to learn C include:<br> <a href="https://alison.com/courses/Diploma-in-Programming-in-C">https://alison.com/courses/Diploma-in-Programming-in-C</a><br> <a href="https://www.udemy.com/c-programming-for-beginners/">https://www.udemy.com/c-programming-for-beginners/</a><br> <a href="http://c.learncodethehardway.org/book/">http://c.learncodethehardway.org/book/</a></p><p><strong>C++</strong> is derived from C and has also been around for quite some time now. It requires at least an intermediate level programming skill to start learning the language. C++ has imperative, object-oriented and generic programming features, making it immensely powerful but also requiring an understanding of several advanced computer-science concepts to master it fully. This language is used mostly for developing systems software, video games, applications software, and client/server applications as well as cloud-based server software.</p><p>Places to learn C++ include:<br> <a href="http://www.learncpp.com/">http://www.learncpp.com/</a><br> <a href="http://www.cplusplus.com/doc/tutorial/">http://www.cplusplus.com/doc/tutorial/</a></p><p><strong>C#</strong>, originally designed by Microsoft as part of their .NET initiative, is used to develop software applications for Windows platforms. Since C# is an essential part of the .NET framework, if you are looking to develop for Microsoft, this is the language for you. It closely resembles Java, so if you know one of them, jumping to the other isn’t so difficult. C#, like Java, was originally invented to bring object-oriented programming concepts to a C-like language without all of the complexity of C++.</p><p>Places to learn C# include:<br> <a href="http://www.microsoftvirtualacademy.com/training-courses/developer-training-with-programming-in-c">http://www.microsoftvirtualacademy.com/training-courses/developer-training-with-programming-in-c</a><br> <a href="https://channel9.msdn.com/Series/C-Fundamentals-for-Absolute-Beginners">https://channel9.msdn.com/Series/C-Fundamentals-for-Absolute-Beginners</a></p><p><strong>Java</strong> is an object-oriented language and currently one of the most widely used languages. Programmers like Java because it is portable by design and runs well across multiple software platforms. Java is a versatile language and can be used for building mobile apps, server-side applications, as well as enterprise software.</p><p>Places to learn Java include:<br> <a href="https://netmeans.org/kb/articles/learn-java.html">https://netmeans.org/kb/articles/learn-java.html</a><br> <a href="http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-092-introudctino-to-programming-in-java-january-iap-2010/">http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-092-introudctino-to-programming-in-java-january-iap-2010/#</a><br> <a href="https://www.codecademy.com/edn/courses/learn-java/">https://www.codecademy.com/edn/courses/learn-java/</a></p><p><strong>R</strong> is a narrowly focused language used for statistical analysis and graphing, including bivariate analysis, and correlation. This language has seen increases in popularity with the high demand for data science both academically and in business where data visualization and analysis are essential to moving projects forward. R is a great choice if you find yourself needing to create any kind of data mining project or if you feel limited by the simple Excel capabilities that are just too primitive to fully analyze correlations that may exist in your data.</p><p>Places to learn R include:<br> <a href="https://cran.r-project.org/manuals.html">https://cran.r-project.org/manuals.html</a><br> <a href="https://www.edx.org/course/introduction-r-programming-microsoft-dat204x-0">https://www.edx.org/course/introduction-r-programming-microsoft-dat204x-0</a><br> <a href="https://www.datacamp.com/courses/free-introduction-to-r">https://www.datacamp.com/courses/free-introduction-to-r</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*M7HTGtiP6HNHOd9zb2s8JA.png" /></figure><p><strong>Python</strong>, touted as one of the easiest programming languages to learn, is a general-purpose, high-level scripting language. Used for creating anything from websites and mobile applications to data analysis, Python boasts a large and comprehensive standard library. Due to its simplicity, Python is also one of the most widely taught programming languages in U.S. schools. If you are new to programming, this is indeed an excellent place to get started.</p><p>Places to learn Python include:<br> <a href="https://www.python.org/doc/">https://www.python.org/doc/</a><br> <a href="http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-189-a-gentle-introduction-to-programming-using-python-january-iap-2011/">http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-189-a-gentle-introduction-to-programming-using-python-january-iap-2011/</a><br> <a href="https://developers.google.com/edu/python/?hl=en">https://developers.google.com/edu/python/?hl=en</a></p><p><strong>Ruby</strong> is another great scripting language that has enjoyed some popularity in the last 10–15 years, but seems to be a bit on a down-trend nowadays. It is used for developing websites and mobile apps. This open-source language has a dedicated community behind it, which makes finding resources to learn Ruby that much easier. Ruby was created in the mid-1990s in Japan by Yukihiro Matsumoto and he blended elements from some of his favorite languages (Perl, Smalltalk, Eiffel, Ada, and Lisp) to create a new language that is inherently object-oriented and functional.</p><p>Places to learn Ruby include:</p><p><a href="https://www.ruby-lang.org/en/documentation/quickstart/">https://www.ruby-lang.org/en/documentation/quickstart/</a><br> <a href="https://rubymonk.com/">https://rubymonk.com/</a></p><p><strong>JavaScript</strong> is a Java based language that is frequently used to add programmability to HTML web pages. It is a fairly simple language to learn and many hands on tutorials can be found around the web to help you get started. It is most often executed inside a web browser, although other server-side applications are also possible. In recent years JavaScript also has spread into more domains, including mobile apps, and even some embedded devices.</p><p>JavaScript uses a built-in serialization format to write objects from memory into a disk or stream, called <a href="http://www.altova.com/xmlspy/json-editor.html">JSON</a> (JavaScript Object Notation), and JSON has gained popularity for transmitting data between computers in a way that is similar to XML, as a quick efficient way to transfer data, so knowing JavaScript sets you up for proficiency with JSON and <a href="http://www.altova.com/xmlspy/json-schema-editor.html">JSON Schema</a>, both prerequisites for building web and web services applications.</p><p>Places to learn JavaScript include:<br> <a href="https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide">https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide</a><br> <a href="https://www.codecademy.com/tracks/javascript">https://www.codecademy.com/tracks/javascript</a></p><p><strong>SQL </strong>or Structured Query Language is a database query language used for managing data in relational databases. Who should learn SQL? Everyone! SQL is everywhere and learning it is not that difficult. If you ever have a need to retrieve or manipulate data in a database (and let’s face it who wouldn’t benefit from this ability) this is a great language to learn.</p><p>Places to learn SQL:<br> <a href="https://www.codecademy.com/learn/learn-sql">https://www.codecademy.com/learn/learn-sql</a><br> <a href="http://www.sqlcourse.com/">http://www.sqlcourse.com/</a><br> <a href="http://www.w3schools.com/sql/">http://www.w3schools.com/sql/</a><br> <a href="http://www.tutorialspoint.com/sql/">http://www.tutorialspoint.com/sql/</a></p><p><strong>XQuery </strong>is the XML Query Language, a functional programming language designed for both querying and transforming XML data. According to the <a href="https://www.w3.org/XML/Query/">W3C</a>, XQuery is replacing complex Java or C++ programs with a few lines of code because it is simpler to work with and easier to maintain. XQuery is also now the language of choice for powerful data manipulation from a broad range of data sources in mobile platforms, such as <a href="http://www.altova.com/mobiletogether.html">Altova MobileTogether</a>. XQuery is very powerful and not a difficult language to learn.</p><p>Places to learn XQuery:<br> <a href="http://www.altova.com/training/xquery3/">http://www.altova.com/training/xquery3/</a><br> <a href="http://www.w3schools.com/xsl/xquery_intro.asp">http://www.w3schools.com/xsl/xquery_intro.asp</a><br> <a href="http://www.tutorialspoint.com/xquery/">http://www.tutorialspoint.com/xquery/</a><br> In addition to all these online resources, there are also many excellent books on all these languages available on Amazon, so make sure you check those out as well and look for customer reviews before you decide which one to buy.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*OFu8Fj8MeWNTlQTKFHa2uA.png" /></figure><p>You can’t pick a bad language to put in your bag of tricks; in fact, each one will only add to your marketability. So dive in and start learning a new programming language this summer!</p><p><em>Originally published at </em><a href="http://blog.altova.com/learning-new-programming-language-summer/"><em>blog.altova.com</em></a><em> on May 31, 2016.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=65ada83825bf" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[New Features for Mobile Development]]></title>
            <link>https://medium.com/@afalk/new-features-for-mobile-development-a7b73bbdc95f?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/a7b73bbdc95f</guid>
            <category><![CDATA[ux]]></category>
            <category><![CDATA[mobile-app-development]]></category>
            <category><![CDATA[mobile]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Tue, 29 Mar 2016 18:52:45 GMT</pubDate>
            <atom:updated>2016-04-06T13:42:48.244Z</atom:updated>
            <content:encoded><![CDATA[<p>The latest version of MobileTogether is available today, adding even more functionality to this game-changing framework for building and deploying native mobile apps faster than any other solution.</p><p>To start with, we’ve completely revised the pricing for MobileTogether, with a new model that’s simple to understand and ridiculously affordable.</p><p>In addition, Version 2.1 introduces over 30 important new features added based on real-world developer feedback, from new functionality for building tables, to sophisticated error handling actions, to flexible options for beautiful UI design.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*LmGHR4AEV2-f23yKntn39Q.png" /></figure><p>Let’s take a look at how these new features combine to let you build the most sophisticated data-centric apps for iOS, Android, and Windows devices.</p><h3>Completely New Pricing</h3><p>MobileTogether has broken most of the barriers to mobile development, making it easier and faster than ever before to develop great apps for all platforms. Now, we’re breaking down the final roadblock: cost. With the MobileTogether 2.1 launch, we’re rolling out a simplified pricing plan designed to get you up and running at light speed.</p><h4>Unlimited Apps, Unlimited Users, Unlimited Developers</h4><p>As always, the MobileTogether Designer app development environment is free-of-charge, so you can roll it out to an unlimited number of developers in your company. Now, we’ve drastically reduced the costs for the app server, as well. MobileTogether Server is now available with per server core prices starting at $1000 per year. <strong>That’s right: it’s $1000 annually for an unlimited number of apps, and an unlimited number of users.</strong></p><p>While there’s no limit to the number of users or number of apps that you can run on the mobile app server, you may, of course need to scale the server machine depending on actual load, to provide optimal performance for larger numbers of users. But the starting price is perfect for most initial deployments.</p><p>With this radically reduced pricing structure, and the new features described below, we’ve aimed to make MobileTogether the most accessible — and most sophisticated — framework for developing data-centric apps for all platforms.</p><h3>Enhancements to Tables in MobileTogether 2.1</h3><p>Tables are a fundamental element of any mobile app, and MobileTogether includes powerful enhancements for building tables of any size:</p><ul><li>Scrollable tables: set max height and width to allow horizontal and vertical scrolling</li><li>New property: table row/column background color</li><li>Option to align nested tables</li></ul><p>Support for scrollable tables provides even more flexibility for table creation in MobileTogether. Now, to ensure easy display on devices of all sizes, developers can set the maximum visible size of a table, or set it to fit the rest of the screen, with horizontal or vertical scrolling enabled to view the rest.</p><p>Scrollable tables can be used for more than expanded displays of data, for instance, when a table is used to layout other controls. The scrollable table feature makes it possible to define elements such as navigation bars or other tools that always stay locked at the bottom of the screen as the user scrolls through a larger view.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*5DFYNiqfFCMun-XO5pKPAA.png" /></figure><h3>New Controls</h3><p>New controls in MobileTogether 2.1 allow developers to add familiar visual elements to their sophisticated UIs, making apps even easier for users to understand and operate:</p><ul><li>New Control: Slider</li><li>New Control: Vertical line</li><li>New button looks: Share and Email</li></ul><p>An example of the new horizontal slider control is shown in the app below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*1tplty8BfANU9y1UU_CCVw.png" /></figure><h3>New Actions</h3><p>The new actions included in MobileTogether 2.1 round out the sophisticated Action Tree programming language pioneered by MobileTogether, making this platform powerful enough to build any data centric app imaginable. They include:</p><ul><li>New Action: Share</li><li>New Action: DB Bulk Insert Into</li><li>New Action: Let</li><li>New Action: Return</li><li>Subpages: possibility to return result on close</li><li>Action groups: possibility to pass parameters</li><li>New Action: Try/Catch</li><li>New Action: Throw</li><li>New Action: Cancel Action Execution</li><li>New Action: Scroll to Table Bottom</li><li>New Action: Load Image</li><li>New Action: Show Route</li><li>New Action: Loading/saving files on client devices</li><li>Creating folders automatically when saving files on client or server</li><li>New Action: Delete Files/Folders</li><li>New Action: Restart/Stop Page Timer</li><li>New Action: User Cancel Behavior</li></ul><p>Extensive error handling capabilities are enabled with the new Try/Catch (shown in the Action Tree below), Cancel Action Execution, and related actions. In addition, the ability to pass parameters and return results in action groups lets action groups perform like true programming subroutines.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*B19-Edv22jVitgLuvjo7Jg.png" /></figure><h3>New XPath Functions, Properties, and Operators</h3><ul><li>Flexibility to set some existing properties via XPath</li><li>New property: text size in pixels</li><li>New XPath function: mt-connected-via-wifi</li><li>New XPath function: mt-font-height</li><li>New XPath function: mt-control-width</li><li>New XPath function: mt-user-tried-to-cancel-actions</li><li>Quick search in XPath function dialog</li><li>New option to hide page title bar</li></ul><p>New XPath extension functions help you allow for various scenarios, such as whether the device is connected via Wi-Fi or not, and what the standard font height is on a particular client platform. The option to hide the page title bar gives the app a larger active area, which can be especially helpful on smaller devices.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*x3yqmHPvswqnXvT3p_O0hQ.png" /></figure><h3>New Features that Improve End User Experience</h3><p>A great user experience is the first goal of any data-centric app, and we’re constantly striving to add features aimed directly at helping the end user. New in MobileTogether 2.1:</p><ul><li>Customizable login/index page for browser client</li><li>Speed up of app starts when connection is slow</li><li>New keyboard style: Visible Password</li></ul><p>Now, even when a connection is slow, MobileTogether apps will start much faster. Developers can also specify a more user-friendly introductory page when an app is accessed via the browser-based client.</p><h3>New Demo App: MyCollections</h3><p>There’s a new sample app on the demo server of the MobileTogether universal client app called MyCollections.</p><p>MyCollections is a highly flexible and expandable mobile database app for managing your personal collections. MyCollections includes built-in templates for audio CDs, books, and wine that can be used as-is, customized with new enhancements, or viewed as merely a starting point for any other collection. You can add photos, create and format new descriptive fields, and customize My Collections to suit the particulars of your keepsakes. You can even share your collections with friends.</p><p>My Collections was built with the MobileTogether mobile development framework and demonstrates many of the new features available in MobileTogether 2.1.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*53kvaPI72Ai2MA3_KxT53w.png" /></figure><h3>Get MobileTogether 2.1</h3><p><a href="http://www.altova.com/whatsnew_mobiletogether.html">Read more</a> about these new features, or <a href="http://www.altova.com/download/mobiletogether.html">update your MobileTogether software</a> for free now.</p><p>If you’re not already a customer, get started with the <a href="http://www.altova.com/download/mobiletogether.html">free MobileTogether Designer</a>!</p><p><em>Originally published at </em><a href="http://blog.altova.com/new-features-mobile-development/"><em>blog.altova.com</em></a><em> on March 29, 2016.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a7b73bbdc95f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Demand These 10 Features For Mobile App Development]]></title>
            <link>https://medium.com/@afalk/demand-these-10-features-for-mobile-app-development-4288e98ac08f?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/4288e98ac08f</guid>
            <category><![CDATA[cross-platform]]></category>
            <category><![CDATA[developer-tools]]></category>
            <category><![CDATA[mobile-app-development]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Mon, 01 Feb 2016 23:19:10 GMT</pubDate>
            <atom:updated>2016-02-01T23:21:53.065Z</atom:updated>
            <content:encoded><![CDATA[<p>“<em>We need an app for that</em>.”</p><p>This simple declaration carries with it underlying implications that can be anything but simple to implement: an app must be available for all devices, it must delight end users — and it must be ready yesterday.</p><p>As the need for mobility in data centric apps has increased, so has the number of products claiming to provide the best in cross-platform mobile development. But how can you cut through the flowery marketing claims? We’ve put together a list of the top 10 criteria for choosing a mobile development framework.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*le-k_nL8cgJKMm85.jpg" /></figure><h3>10 Must-Have Features For Mobile App Development</h3><h4><strong>1. Develop native apps for all platforms</strong></h4><p>Building a wrapper around HTML5 and JavaScript is a common approach, but it’s simply <a href="http://blog.altova.com/wrapper-around-html5-and-javascript/">not enough</a>. Only true native apps have access to the critical mobile platform functions required for a sophisticated app and a seamless user experience. If you want your app to take advantage of inherent functionality of mobile devices, such as sending emails or texts, signature capture, camera integration, geolocation, and so on, you’ve got to develop native apps for iOS, Android, Windows Phone, and Windows.</p><h4><strong>2. Provide a single integrated development environment</strong></h4><p>It goes without saying that <a href="http://www.altova.com/mobiletogether/develop-apps-fast.html">time is not on your side</a> when you’re building an app. Rather than waste time with writing code manually against native platform SDKs or developing separate UIs for each platform, look for a product that does that work for you — so you can focus your time on the business logic and functionally of your app.</p><h4><strong>3. Design both the app front end and the backend server logic at once</strong></h4><p>Your app is more than just a beautiful UI. It’s the brains of the system — the data processing and delivery — that’re going to get you the five star rating. A complete mobile app framework includes not only the front end but powerful back end server software for comprehensive workflow execution, data integration, server-powered data calculation, and so on. Whether it lives in your network or in the cloud, you want the backend processing server for your app to be lightning fast and powerful to deliver the best user experience.</p><h4><strong>4. Connect to all major back end data systems</strong></h4><p>Systems compatible with a single platform or database vendor are too rigid and won’t stand the test of time as requirements and software evolve. You need connectivity to any data source, whether that’s in one or more relational database systems, on the Web, in XML or JSON, and so on. Look for flexibility, not silos.</p><h4><strong>5. Complete full-featured apps as quickly as possible</strong></h4><p>Time is a recurring theme in this list. In reality, any app that takes longer than a month or two from zero to live is going to be obsolete before it hits the app stores. Requirements change; competitors creep; windows of opportunity are missed. There’s no reason you can’t get a kick ass app out the door in days with the right tools.</p><h4><strong>6. Go beyond simply mobilizing desktop productivity processes</strong></h4><p>The goal of app development should be to <em>add</em> <em>value</em> to existing processes — not simply turn on mobile access. Your app development platform should enable you to unearth entirely new ways of viewing, analyzing, reporting, and capturing data.</p><h4><strong>7. Utilize in-house development or IT teams</strong></h4><p>With the right IDE, desktop developers and IT power users can develop sophisticated mobile apps. Hiring specialized mobile developers — if you can even find and recruit them — is time consuming and expensive. An app development solution should be easy enough that citizen developers can grasp it, while being powerful enough to delight experienced developers. It is possible.</p><h4><strong>8. Don’t forget the desktop: apps must work on ANY screen</strong></h4><p>Through it all, remember that the key to mobile success is not the device, but the user. He or she rotates between smartphone, tablet, and laptop, and your app must work equally well on any screen. An app is an app. The user decides where to use it. Make sure your mobile development solution doesn’t neglect the desktop.</p><h4><strong>9. Provide options for enterprise and consumer end-users</strong></h4><p>Enterprise mobility brings with it a unique set of challenges: security requirements, ease of deployment considerations, budgetary limits, developer resource constraints, and the list goes on. As a developer you want a product that can handle deploying apps in-house as well as via the app stores.</p><h4><strong>10. Offer scalable, fully transparent pricing for organizations of any size</strong></h4><p>Know your options before you begin. Nothing’s worse than developing an app only to discover that your deployment scenario requires tens of thousands of dollars just to get your app out the door. Choose a product with a low cost of entry that scales as your app is adopted. Be suspicious when pricing is unavailable.</p><p>It’s no surprise that Altova <a href="http://www.altova.com/mobiletogether.html">MobileTogether</a> was designed to meet all these requirements. Whether your app is destined for the enterprise or for consumers via the app stores, you can build it in MobileTogether quickly and easily, without sacrificing the functionality or sophistication your users expect.</p><p>MobileTogether is the result of years of work and testing, during which we listened to our customers, and we listened to our in-house developers who were building apps. The framework grew from that feedback and end user input, not from flowery promises.</p><p>The pricing structure is flexible. In fact, you can <a href="http://www.altova.com/download/mobiletogether.html">build and test a full-fledged app</a> before ever taking out your credit card.</p><p>In a world where “We need an app for that,” is a given, <a href="http://www.altova.com/mobiletogether/technical-overview.html">mobile app development</a> should be easy and affordable, and you should be able to check off all the requirements on your list.</p><p>Originally published on the <a href="http://blog.altova.com/top-features-mobile-app-development/">Altova Blog</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4288e98ac08f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Using Google Cloud SQL]]></title>
            <link>https://medium.com/google-cloud/using-google-cloud-sql-e3e4c123a89f?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/e3e4c123a89f</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[google-cloud-platform]]></category>
            <category><![CDATA[cloud-computing]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Wed, 06 Jan 2016 09:29:17 GMT</pubDate>
            <atom:updated>2016-01-06T15:17:59.424Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*zfuUDJ50xWrXLpyNM4j9og.jpeg" /></figure><p>Google <a href="http://googlecloudplatform.blogspot.com/2015/12/the-next-generation-of-managed-MySQL-offerings-on-Cloud-SQL.html">recently announced</a> their next generation of managed MySQL offerings on Cloud SQL, so we wanted to take it for a spin and create a cloud-based SQL database that we could then utilize as the back-end for mobile apps, or even for advanced data analytics from our desktop.</p><p>According to Google, the two principal goals of the second generation of Cloud SQL were better <em>performance</em> and <em>scalability</em> per dollar. It seems that they succeeded in these goals: the second generation Cloud SQL is more than seven times faster than the first. And it scales to 10TB of data, 15,000 IOPS, and 104GB of RAM per instance — well beyond the first generation. So it looks like the ideal, scalable cloud-based database back-end for mobile apps.</p><p>If you follow the instructions on the the <a href="http://googlecloudplatform.blogspot.com/2015/12/the-next-generation-of-managed-MySQL-offerings-on-Cloud-SQL.html">Google blog post</a>, you will first have to create a trial account for Google Cloud. Then, once you are logged into the Google Developer Console, click on the top-left menu button and select SQL under the storage section. This will enable you to create a new second generation Cloud SQL instance:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bgm1zWA4ny-Ki027VBUr-A.png" /></figure><p>It is highly recommended to change your root password and to only allow access to your cloud instance from authorized networks that will host your developer machines, or your back-end servers for the mobile app that you are building. For example, if a future blog post we will explore building a mobile app on top of this database, and the <a href="http://www.altova.com/mobiletogether/server.html">MobileTogether back-end server</a> that will provide all the server functionality and workflow for our mobile app will need to be able to access this Cloud SQL instance.</p><p>In order to use the Cloud SQL instance from your desktop developer machine, you will need to <a href="http://dev.mysql.com/downloads/">download the MySQL tools</a> for your machine, which will enable you to use the <strong>mysql</strong> command-line tool. Also, to use the Cloud SQL database from other applications on your computer, you will need to download the respective <a href="http://dev.mysql.com/downloads/connector/">MySQL Connectors</a>. In this blog post we’ll be using <a href="http://www.altova.com/databasespy.html">Altova DatabaseSpy</a> to access the SQL instance, upload some data, and then perform some analysis, so you’ll want to <a href="http://dev.mysql.com/downloads/connector/odbc/">download the MySQL Connector/ODBC for Windows</a>. Essentially, DatabaseSpy is similar to Toad, but allows you to connect to multiple different database instances on different database servers at the same time. So you can have one connection open to Cloud SQL, one connection to a local SQL Server, and a third connection to an Oracle Database — all from within one workspace. Pretty nifty.</p><p>One important note: you’ll want to make sure that you download the right Connector/ODBC driver. If you’re using the 64-bit version of DatabaseSpy, you’ll also need the 64-bit version of the MySQL Connector/ODBC driver. Or, better yet, you can download both the 32-bit and 64-bit versions of Connector/ODBC and install them both — then you can use Cloud SQL from both 32-bit and 64-bit software on your machine.</p><p>To populate our Cloud SQL instance with some useful data for experimentation and further analysis, we downloaded the excellent <a href="http://www.seanlahman.com/baseball-archive/statistics/">Lahman’s Baseball Database</a>, which is conveniently available as a zipped MySQL dump. After downloading this onto our computer, we had a complete SQL database table descriptions plus all the data — all in one SQL file, so it can be easily uploaded into our Cloud SQL instance.</p><p>The first step is to <a href="https://cloud.google.com/sql/docs/create-database">create a new database in your Cloud SQL</a> instance. You can do that either via the command-line mysql utility, via the Google Developer Console, or via cURL — see link at the beginning of this paragraph for more details. We will simply call this database “lahman”.</p><p>Now we can connect to this database from DatabaseSpy by choosing the “Connect to a database” command and following these steps through the connection wizard. First we select MySQL as the database technology:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/881/1*jJ0EX0Jt2B_1JfRemgJq9g.png" /></figure><p>Then we confirm the use of the MySQL Connector/ODBC driver that we have downloaded previously:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/879/1*u1h6QSv1QN3kdGMsylMDtQ.png" /></figure><p>And last, but not least, we specify the IP address, username, and password of our Cloud SQL instance, then hit the “Test” button to verify the connection. If that works, we can now create a data source by giving it a name, and also specify the “lahman” database that we previously created:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/626/1*ER71GON9OaLdRD9m9bl8Iw.png" /></figure><p>Now we’re ready to upload all the data into tables in our new database. To do that, we simply open the SQL dump of the Lahman Baseball Database that we previously downloaded and unpacked, which looks like this in DatabaseSpy:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DN7ly6Ia-1c-KLSbl2GerA.png" /></figure><p>As you can see, the SQL dump of that database contains all the necessary commands to recreate all the tables on our new Cloud SQL instance. So all we have to do now is hit the “Execute” button and sit back. Depending on your Internet connection speed, this may take a little while, as you’re now creating 24 tables with highly detailed baseball statistics from 1871 until 2014 — some of which have over 160,000 rows. In my case it took about 8 minutes to complete.</p><p>Now you can hit “Refresh” in your Online Database Browser in DatabaseSpy and then explore all the tables and the data contained therein, and the <a href="http://seanlahman.com/files/database/readme2014.txt">structure of the Lahman database</a>. And you can use this database to calculate interesting historical data, do statistical analysis, and apply other tools often used in <a href="https://en.wikipedia.org/wiki/Sabermetrics">Sabermetrics </a>to better understand the quality of players.</p><p>As an example, we will look at <a href="http://www.baseball-reference.com/players/o/ortizda01.shtml">David Ortiz</a>‘s percentage of homeruns (HR) hit for every at-bat (AB) over his entire career and will plot that as a function of his age. You will find a player’s at-bat performance in the “Batting” table and his name, birth date, etc., in the “Master” table. Joining the two tables in SQL and selecting the data for David Ortiz is easy, and we can then calculate his Career HR Trajectory simply as HR/AB and plot that against his age in a given year:</p><pre>SELECT yearID-birthYear AS Age, HR/AB AS CareerHRTrajectory FROM Batting, `Master` WHERE Batting.playerID = `Master`.playerID AND nameLast=&#39;Ortiz&#39; AND nameFirst=&#39;David&#39; ORDER BY Age ASC</pre><p>Once you hit “Execute”, this query is sent to the Cloud SQL instance and the resulting data is returned almost instantaneously as a table. You can then hit the “Graph” button in the result table view to graph the data and plot the Career HR Trajectory over his age:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*tZ5EOK09XfMGcLOVvtFyOA.png" /></figure><p>As you can see, it is very easy to connect to and utilize the new Google Cloud SQL instances from <a href="http://www.altova.com/databasespy.html">Altova DatabaseSpy</a> or, for that matter, from any of the other <a href="http://www.altova.com/">Altova</a> developer tools, including <a href="http://www.altova.com/xmlspy.html">XMLSpy</a>, <a href="http://www.altova.com/mapforce.html">MapForce</a>, <a href="http://www.altova.com/mobiletogether.html">MobileTogether</a>, <a href="http://www.altova.com/stylevision.html">StyleVision</a>, and <a href="http://www.altova.com/umodel.html">UModel</a>. In addition, you can easily utilize Cloud SQL instances from <a href="http://www.altova.com/mapforce/mapforce-server.html">MapForce server</a> for data integration and conversion projects.</p><p>In a future blog post we will connect to this Cloud SQL instance from a mobile app and explore how easy it is to build a convenient mobile app front-end on top of the Lahman baseball database.</p><p><em>Originally published at </em><a href="http://blog.altova.com/using-google-cloud-sql/"><em>blog.altova.com</em></a><em> on January 6, 2016.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e3e4c123a89f" width="1" height="1" alt=""><hr><p><a href="https://medium.com/google-cloud/using-google-cloud-sql-e3e4c123a89f">Using Google Cloud SQL</a> was originally published in <a href="https://medium.com/google-cloud">Google Cloud - Community</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Getting Company Financials Data on your Mobile Device]]></title>
            <link>https://medium.com/@afalk/getting-company-financials-data-on-your-mobile-device-cb92cb6f78e?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/cb92cb6f78e</guid>
            <category><![CDATA[xbrl]]></category>
            <category><![CDATA[stock-market]]></category>
            <category><![CDATA[mobile]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Wed, 16 Dec 2015 07:55:44 GMT</pubDate>
            <atom:updated>2015-12-16T21:57:47.803Z</atom:updated>
            <content:encoded><![CDATA[<p>US public companies are required to file their company financials — including income statements, balance sheets, and cash flow statements — quarterly and annually with the U.S. Securities and Exchange Commission (SEC). These financial reports provide a snapshot of the financial health of a corporation and any investor interested in fundamental analysis will typically be looking at these reports in great detail and performing financial analysis, including the calculation of important financial ratios.</p><p>We have just published the free Company Financials App for iOS, Android, Windows Phone, and Windows 8.1/10 that lets you explore and analyze US public company high-level financial reports automatically extracted from the XBRL filings in the SEC’s EDGAR database. You can search by company name or stock ticker symbol and view the financial reports of the last four quarters or last four years, as well as charts of annual or quarterly data reaching back several years.</p><p>In addition, various financial ratios, such as current ratio, quick ratio, cash ratio, gross profit margin, operating profit margin, return on assets, return on equity, debt/equity ratio, capitalization ratio, asset turnover, free cash flow, and many others, are calculated and displayed for the last four quarters or last four years. This makes the Company Financials app very useful for education purposes, such as business school programs in the area of accounting, finance, or corporate management.</p><p>The Company Financials App is immediately available in the respective app stores and is designed for smartphones and tablets, as well as laptop and desktop PCs:</p><p><a href="https://itunes.apple.com/us/app/company-financials/id1063006406?ls=1&amp;mt=8"><strong>Download iOS App from Apple App Store</strong></a></p><p><a href="https://play.google.com/store/apps/details?id=com.altova.companyfinancials"><strong>Download Android App from Google Play Store</strong></a></p><p><a href="https://www.microsoft.com/store/apps/9nblggh6j0pw"><strong>Download Windows App from Microsoft</strong></a></p><p>This cross-platform mobile app for Android, iOS, and Windows was developed using <a href="http://www.altova.com/MobileTogether">Altova MobileTogether 2.0</a> — a powerful framework for building data-centric mobile apps.</p><p>New company filings are processed and added to the database every night and will be available in this app on the next morning. For additional information about how the data was downloaded, analyzed, prepared, and aggregated using Altova RaptorXML+XBRL Server, as well as how you can easily build your own apps utilizing this data, please <a href="http://blog.altova.com/financial-analysis-of-xbrl-corporate-filings-on-mobile-devices/">see our recent blog post</a>.</p><p>Altova is a member of XBRL.US and the <a href="https://xbrl.us/home/data-quality/center/">XBRL US Center for Data Quality</a> to support the Data Quality Committee’s initiative to address the public’s concerns about the quality and usability of XBRL financial data filed with the SEC.</p><p><em>Originally published at </em><a href="http://blog.altova.com/company-financials-app-now-available/"><em>blog.altova.com</em></a><em> on December 16, 2015.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cb92cb6f78e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Financial Analysis of XBRL Filings on Mobile Devices]]></title>
            <link>https://medium.com/@afalk/financial-analysis-of-xbrl-filings-on-mobile-devices-f0341e100e19?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/f0341e100e19</guid>
            <category><![CDATA[mobile]]></category>
            <category><![CDATA[xbrl]]></category>
            <category><![CDATA[financial-ananlysis]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Mon, 02 Nov 2015 15:43:49 GMT</pubDate>
            <atom:updated>2015-11-02T15:43:49.812Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*IX5vwiy05dHRcGuUh5EIBQ.png" /></figure><p>In a <a href="http://blog.altova.com/xbrl-data-quality-of-sec-filings/">previous blog post we’ve described some of the problems that are encountered when processing corporate filings from the SEC’s EDGAR database in XBRL</a>. Today we present a system that overcomes these issues by downloading and processing XBRL filings on a daily basis, normalizing the financial data, computing common financial ratios, storing all data into a SQLite database, and then presenting the corporate reporting data for financial analysis through a mobile app for iOS, Android, and Windows Phone.</p><p>We are making all the sources for the data ingestion and normalization process <a href="https://github.com/altova/SECDB">available as Python scripts on GitHub</a> under an <a href="https://github.com/altova/SECDB/blob/master/LICENSE">Apache 2.0 license</a>. The actual normalization rules as well as the financial ratios being computed are defined in external JSON files that can easily be modified without the need to edit the Python sources. In addition the MobileTogether Design file describing the mobile app is also <a href="https://github.com/altova/SECDB">available as open source in the same repository on GitHub</a> so the mobile application can be easily customized as well to graph different data, show other financial ratios, or do more sophisticated financial analysis.</p><h3>Architecture</h3><p>The system utilizes three Altova Server products running on a Windows 2012 server machine to provide data ingestion and processing as well as the back-end for the mobile application:</p><ol><li><a href="http://www.altova.com/flowforce.html">FlowForce Server</a> is used as a workflow scheduler to run a nightly batch job to download new XBRL filings from the SEC’s EDGAR database and then process them accordingly.</li><li>Filings are analyzed and processed by <a href="http://www.altova.com/raptorxml.html">RaptorXML+XBRL Server</a> and financial data is normalized and extracted into a SQLite database via Python scripts, using the built-in Python interpreter in RaptorXML. In order to make the system easy to customize, the normalization logic is not directly encoded in Python, but described in the form of external JSON files that specify the processing rules separately for normalizing income statements, balance sheets, and cash flow statements. Similarly, JSON files are used to describe the calculations needed to compute the financial ratios that are stored in the database.</li><li><a href="http://www.altova.com/mobiletogether/server.html">MobileTogether Server</a> is used to power a mobile app that provides easy access to the resulting data in the SQLite database for financial analysis from mobile devices. The MobileTogether client app can be used on mobile phone or tablet devices running iOS, Android, or Windows Phone, as well as on desktops or laptops running Windows 8, 8.1, or 10.</li></ol><p>These three servers could also be run in the cloud, on a Linux box, or even a Mac, depending on your IT preferences, as the three server products are available for Windows, Linux, and MacOS platforms and can be deployed on-premises or in the cloud.</p><h3>Mobile App</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/803/0*O_e-GMnafBj9QNrG.png" /></figure><p>The mobile app was built with Altova MobileTogether Designer in order to provide a cross-platform mobile app and to make it easily extensible. While the current app only allows looking up one company and then viewing its financial reports, it can easily be expanded to do industry comparisons or run a stock screener.</p><p>We provide this app as an example that can easily be modified by people to create tailored mobile in-house apps for more sophisticated financial analysis as needed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/779/0*5nwbSnqvM5q2VPcO.png" /></figure><p>You can look up companies using either a name match and then selecting from a list, or by entering the ticker symbol.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/708/0*3aMMho9wa_s0afYR.png" /></figure><p>Once a company is found, we show four columns of either quarterly or annual data for the normalized financial statements. The user can toggle the display in millions or thousands as appropriate. The device can be rotated to landscape mode, and the font size can be adjusted as needed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/646/0*pU5Ks1m5pseZwph_.png" /></figure><p>For example, here is the quarterly balance sheet view with a graph of the asset and debt growth since 2009. We’ve decided to also plot Debt to Assets % as a line in the graph. You can easily change what is being plotted here, since we are also making the MobileTogether Design file available as open-source.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/641/0*jXWWn47SXHCK77yz.png" /></figure><p>Similarly, here is the Cash Flow statement shown in the annual view. We’re graphing Operating, Investing, and Financing Cash Flows.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/648/0*7ILfswko1NYh9I1l.png" /></figure><p>Last, but not least, we calculate a number of common financial ratios from the normalized financial statements, shown here as trailing twelve months view.</p><p>Since the Python code to build and fill the database is available as open-source, you can use this as a starting point and customize as needed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/790/0*MSMVGtV9ojTOGNCK.png" /></figure><p>We also show the list of 10-Q and 10-K filings that were used as the source of the presented information. The user can click or tap on any filing and go straight to the web browser to view the original filing on the SEC’s website.</p><h3>Back-end Python scripts</h3><p>The processing of XBRL filings from the SEC’s servers on our back-end system is done using <a href="http://www.altova.com/raptorxml.html">RaptorXML+XBRL Server</a>, a powerful XBRL processing engine that can be used as a platform for sophisticated financial systems. RaptorXML comes with a complete API and is fully scriptable using the built-in Python interpreter.</p><p>We have made <a href="https://github.com/altova/SECDB">all the Python scripts for this project available as open source on GitHub</a>. These scripts include the following:</p><h3>Download EDGAR RSS feeds</h3><p>The SEC maintains RSS feeds for each month with the filings submitted during that month. These feeds can be accessed on the SEC website under <a href="https://www.sec.gov/Archives/edgar/monthly/">https://www.sec.gov/Archives/edgar/monthly/</a>. The script download_feeds.py will download all the available RSS feeds (by default starting from 2005) and store them within the feeds subfolder. The script can be re-run regularly as it will check for already present feeds and download only the latest or missing feeds.</p><h3>Download SEC filings</h3><p>The actual XBRL filings can also be downloaded as zip archives from the SEC. The EDGAR RSS feeds contain amongst other meta-information the URL to the zip archive for a given filing. The script download_filings.py iterates over each feed item and downloads the zip archive into a filings subfolder. Please note that there are over 150,000 filings to this date and downloading them will take several hours and require &gt;30GB of hard-drive space. If you plan to download all of the filings, please do it during the nighttime or on weekends in order to not put too much strain on the SEC’s servers.</p><h3>Create and populate the SEC DB</h3><p>The script build_secdb.py analyzes quarterly (10-Q) and annual (10-K) corporate filings and computes a normalized summary view of the main financial statements. The data for the balance sheet, income statement and cash-flow statement as well as some common financial ratios are then stored into a database. Please refer to the <a href="https://github.com/altova/SECDB/blob/master/docs/DB-SCHEMA.md">additional documentation describing the database schema and tables</a> in more detail.</p><h3>Automating retrieval and processing of new EDGAR filings</h3><p>In order to keep the SEC DB up-to-date one needs to refresh the EDGAR RSS feed, download all new XBRL filings and finally process those filings and store the data into the SEC DB. This entire workflow is automated by the daily_update.py script. It performas all necessary tasks to keep the SEC DB up-to-date. The script can be run on a daily, weekly or monthly basis from Altova FlowForce Server as a commandline function (or could be automated as a crontab batch job on Linux systems, if no other complex workflow logic is required).</p><p>For further information and more details, please see the <a href="https://github.com/altova/SECDB/tree/master/docs">full documentation of those scripts here on GitHub</a>.</p><h3>How to get started</h3><p>If you’re happy with the way the mobile app looks and the data that is being displayed, you can start using the mobile app “as is” right away (and it’s free):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/579/0*W7mvTJ5AbflVcomX.png" /></figure><p>1. Download the <strong>MobileTogether</strong> app from the AppStore on your phone. It’s available for iOS, Android, and Windows Phone.</p><p>2. In the MobileTogether app add a new server with the address: <strong>secdb.altova.com</strong> and port <strong>80</strong> and leave the user as <em>anonymous</em> and the password empty.</p><p>3. Done! You can now use the app to look up financial statements as shown here today.</p><p>If you want to customize the normalization, build your own database, add different financial analysis, or calculate other ratios:</p><p>If you want to customize the mobile application views and graphs:</p><ol><li>Download and install the free <strong>MobileTogether Designer </strong>software from: <a href="http://www.altova.com/download/mobiletogether.html">http://www.altova.com/download/mobiletogether.html</a></li><li>Download the SECdb.mtd file from the GitHub repository and open it with MobileTogether Designer. You can now customize the data that is being rendered in the graphs, as well as the tables being displayed, their formatting, and any additional calculations.</li></ol><p>Further documentation for the Python scripts is available in the <a href="https://github.com/altova/SECDB/tree/master/docs">/docs subdirectory of the GitHub repository</a>.</p><p>We hope this mobile app is helpful for overcoming some of the challenges associated with processing corporate filings from the SEC database. Please let us know how it works for you and how we can make it better. We’d also love to hear about any customization you do to extend the solution.</p><p><em>Originally published at </em><a href="http://blog.altova.com/financial-analysis-of-xbrl-corporate-filings-on-mobile-devices/"><em>blog.altova.com</em></a><em> on November 2, 2015.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f0341e100e19" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to stay productive in the age of distraction]]></title>
            <link>https://medium.com/@afalk/how-to-stay-productive-in-the-age-of-distraction-2254be4648c5?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/2254be4648c5</guid>
            <category><![CDATA[getting-things-done]]></category>
            <category><![CDATA[email]]></category>
            <category><![CDATA[productivity]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Wed, 28 Oct 2015 12:17:44 GMT</pubDate>
            <atom:updated>2015-10-28T16:56:56.214Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*bZOTcBlAlbLwUXZNsmJP0Q.jpeg" /></figure><p>If you live in the 21stcentury and are not actually hiding underneath a rock or living in a cave, you probably are suffering from some form of information overload and feel overburdened by the number of things you have to do at any given moment in time. New information is constantly coming at you in the form of Twitter, Facebook, WhatsApp, text messages, or the latest social media app you installed on your smartphone, as well as good old radio, TV, newspapers, and magazines in their classic or digital versions, not to mention work or school email, personal email from friends and family, and all the social obligations from clubs, charities, and local community organizations.</p><p>So how do you actually manage to stay productive and deal with this onslaught of information without going crazy? How do you get things done, achieve your goals, and get to the mountaintop despite the constant head-wind?</p><p>I’ve been fascinated with the question of how to manage my own productivity since the start of my career in the software industry and still quite fondly remember the days in the late 80s when I carried around a <a href="http://shop.timemanager.com/shop/us/frontpage.html">TMI Time Manager</a> to help me stay focused, organized, and on-task. This little binder with its calendar, key-lists, goals, and address book was certainly a great productivity tool back then, but ever since we’ve had software and hand-held gadgets for calendar, contact, and to-do list management starting in the early 90s (e.g. <a href="https://en.wikipedia.org/wiki/IBM_Notes#Release_history">Lotus Notes</a>, <a href="https://en.wikipedia.org/wiki/Microsoft_Outlook#Versions">Outlook</a>, <a href="https://en.wikipedia.org/wiki/Palm_%28PDA%29#History">Palm</a>), I’ve migrated to using electronic productivity tools (to my surprise, these Time Manager binders still seem to be around today — see <a href="https://www.youtube.com/watch?v=Dk3_QqHAxpY">this video here from 2013</a>).</p><p>However, even with the plethora of available productivity tools that we have at our disposal today, people are still overwhelmed and feel out of control. We’ve had these tools — including email for improved communications — for over 30 years now and yet most of us are still struggling with how to be productive and manage information flows efficiently. So the answer must be found not just in <em>which</em> tools to use, but even more importantly in the methodology of <em>how</em> we use those tools to our advantage.</p><h3>Email</h3><p>Email is probably the most widely used communication tool in the world today, yet it is likely also the most misused tool and a constant source of frustration for so many people. I’ve used email since the early days of <a href="https://en.wikipedia.org/wiki/ARPANET">Arpanet</a>, <a href="https://en.wikipedia.org/wiki/BITNET">Bitnet</a>, and <a href="http://www.eweek.com/networking/30-years-ago-how-hayes-modems-bulletin-boards-presaged-the-web.html">various BBSs</a> — and over all these years I’ve accumulated a few best-practices that I’ve adopted over time and am happy to share here:</p><ul><li>The most important change of behavior you should adopt right away is <em>not</em> to treat your inbox as a to-do list. We’ll talk about to-do lists and the clear need for separating the inbox processing from to-do lists a bit later in this blog post, but for the purpose of our discussion of email management, I cannot stress enough how liberated you will feel the minute you adopt a methodology that assures your inbox is <em>empty</em> at the end of every day or at least at the end of each week. This concept, commonly called “<a href="http://www.43folders.com/izero"><em>Inbox Zero</em></a>“, was prominently advocated by journalist and productivity guru <a href="http://www.merlinmann.com/">Merlin Mann</a> of <a href="http://www.43folders.com/">43 Folders</a> starting in 2007. I recommend you take an hour out of your busy day right now and watch <a href="https://www.youtube.com/watch?v=z9UjeTMb3Yk">Merlin’s excellent talk at Google in July 2007</a>. The slides for the talk can be <a href="http://www.slideshare.net/merlinmann/inbox-zero-actionbased-email">found on SlideShare</a>, too.</li><li>As you adopt a more process-oriented view towards working with your email, I also highly recommend that you start treating email more like a short message service (such as text messages, SMS, or WhatsApp) and less like a medium for writing elaborate essays. Everybody in the world today is getting inundated with email and other information and your average recipient’s attention span will be maybe 10 seconds, possibly even 20–30 seconds, but not much more than that. People will most likely be reading your email on a mobile device, so keeping your messages short, concise, and to the point is vital. Try to keep all of your email messages to <a href="http://five.sentenc.es/">Five Sentences</a> or less.</li><li>A corollary to that thought is that you should use CC sparingly and precisely. You want to make sure that your message goes only to those people who actually need to read it. If you are sent a message with a long CC list, be very mindful of whether you really need to hit the “Reply All” button. Do all of those people need to hear your response, or just the sender?</li><li>Equally important is to use rigorous and aggressive spam-filtering software to ensure that your inbox only receives emails from real people you want to accept messages from (or newsletters from companies that you actually want to hear about). Your choice of tools may be limited by the email provider you use, but I recommend looking into a commercial multi-device security software suite, such as <a href="http://www.bitdefender.com/solutions/total-security-multi-device.html">BitDefender</a>, that includes spam filtering tools in addition to the usual anti-virus and personal firewall tools and protects your PCs, laptops, tablets, and smartphones. In addition, I recommend that you aggressively label every unwanted message as spam in your email software to effectively blacklist the sender. Unsubscribe from all shopping emails, such as the latest shoes from Zappos or the latest Halloween decorations from iParty — junk email is a real time-killer and you can get rid of it all if you systematically unsubscribe or mark them as spam. Turn off all social media email notifications. You don’t need messages from Facebook, Twitter, and other social media sites clogging up your email inbox. These sites are already demanding enough of your attention and time through their respective apps.</li><li>Some modern email clients provide great features to organize your incoming email into separate tabs, threads or groups, which can make processing your email more productive, because you can focus on different kinds of emails one at a time. Also, separating work from personal email by using two separate email addresses can be a great boost to productivity. For my work email I use <a href="https://products.office.com/en-us/outlook/email-and-calendar-software-microsoft-outlook">Outlook 2016</a>, and for my personal email I use <a href="https://www.google.com/inbox/">Google Inbox</a>. Both offer excellent features to allow me to streamline my workflow. On my Android smartphone I also use the <a href="https://play.google.com/store/apps/details?id=com.google.android.apps.inbox&amp;hl=en">Google Inbox</a> app for my personal email, but for my work email I prefer to use the <a href="https://play.google.com/store/apps/details?id=com.syntomo.email&amp;hl=en">MailWise app</a> over both the built-in native Android email client and the Outlook app. Again, keeping personal and work email separated is key.</li><li>If you want to let your email recipients know about these new email policies you’re adopting, you may want to put a page up on your personal website or blog that explains these policies, and then you can reference that page from your email footer automatically in your pre-defined signature. In my case that page is: <a href="http://alexander.falk.us/personalemailpolicy.html">alexander.falk.us/personalemailpolicy</a></li></ul><h3>Messaging for productivity</h3><p>For short and time-sensitive messages to your team members, to your friends, and to your family, email has certainly been replaced by the various message services that abound today. From text-messages on your phone to IM (instant-messaging) services to iMessages on iOS to WhatsApp to Facebook Messenger, there are plenty of choices for services you could use. Perhaps the most important trick to maintain your sanity is to standardize on one such product with your team, friends, and family. If you constantly have to switch between five products and services, you will soon lose track of things. In my world I’ve managed to get all of my family on <a href="http://www.whatsapp.com/">WhatsApp</a> and that has worked reasonably well. And in the office we use <a href="http://www.skype.com/en/business/skype-for-business/">Skype for Business</a>. Try to see if you can standardize. If your entire family runs on iOS, then using iMessage and FaceTime might work well for you. If you have both Android and iOS device users, you may wish to use a product like WhatsApp or Skype that is available on both platforms.</p><h3>To-do lists</h3><p>The importance of keeping things organized in the forms of to-do or task lists has been well established by productivity gurus for many years now. However, most to-do lists that we keep are ill-suited to actually getting things done, because they contain a mix of long-term goals, short-term action items, and fuzzy ideas that require further refinement. In fact, to-do lists alone without a clearly defined process and methodology of how to structure and utilize them are not going to be very efficient. And in reality most of us carry too many to-dos around in our head all the time. Certain things that we didn’t write down but still have to get done keep distracting us from being optimally productive and add to our stress-level.</p><p><a href="https://twitter.com/gtdguy">David Allen</a> has been advocating his <a href="http://gettingthingsdone.com/">Getting Things Done</a> (often abbreviated as GTD) methodology since 2002 when he published his book titled “<a href="http://www.amazon.com/Getting-Things-Done-Stress-Free-Productivity/dp/0143126563/ref=dp_ob_title_bk">Getting Things Done: The Art of Stress-Free Productivity</a>” (now available in a new updated 2015 edition). His GTD method consists of 5 separate steps — Capture / Clarify / Organize / Reflect / Engage — that are designed to help you get a better handle on long-term goals, clearly defined projects, and next-actions for each of those projects that will create a clearly defined system that is easy to implement and follow. If you want to get a first impression of David Allen’s system, I recommend <a href="https://www.youtube.com/watch?v=CHxhjDPKfbY">watching his TEDx talk from 2012</a> and I can also highly recommend buying and reading the <a href="http://www.amazon.com/Getting-Things-Done-Stress-Free-Productivity/dp/0143126563/ref=dp_ob_title_bk">GTD book</a>. For the purpose of this discussion, I’ll just summarize his <a href="http://gettingthingsdone.com/fivesteps/">five steps</a>:</p><ol><li><strong>Capture</strong> — the first step is to take a few hours to write down everything. Capture all thoughts, all to-dos, all goals, all projects, all piles of letters, post-it notes, emails, long-term plans, everything that’s cluttering your desk, your home office, and your mind. In this stage it is only important to capture all of the information as a complete brain-dump — and not to try to organize the information. David Allen recommends to do this on note-cards that you then place into an “IN” tray on your desk, but I prefer to capture everything electronically, so this step resulted in a very long un-ordered list of bullet points in a Word document. Essentially, what you are building is the inbox of your productivity workflow in this step.</li><li><strong>Clarify</strong> — this is probably the most important step in the process (and the one you will need to get used to in order to be successful with this approach). For each item in your new workflow inbox you now need to clarify whether this is an actionable item or not. If it doesn’t require any action, you have three choices: eliminate it, file it as reference material, or incubate it for future inspiration that may lead to action some day. If it is actionable, the question then becomes: is it just one singular action or part of a larger project? If it is part of a project, define the outcome of that project and organize it as a project plan. If it is a singular action, you again have three choices: if it takes less than two minutes, just do it; if you are not the right person to do it, then delegate it; and lastly, if it takes more than two minutes and you have to do it, defer it to a future point in time — either by putting it on your calendar if it needs to be done on a certain date, or by adding it to one or more “next action” lists. See the diagram below for a clarification of this stage…</li><li><strong>Organize</strong> — in order to support the previous clarification step, it is vitally important to organize the various “next action” lists as well as your project plans, reference materials, and lists for ideas that need to incubate. The book talks a lot about paper-based folders and files, but I recommend that you do it all digitally. You need one system for keeping files organized hierarchically and one system for maintaining multiple to-do lists that can be easily accessed. I will discuss my software choices in the cloud tools section below.</li><li><strong>Reflect</strong> — in order to keep this system going, it is important to include daily and weekly periods of reflection: times when you will look over your lists, update them, maybe move items from a project list onto a next action list, and keep them current.</li><li><strong>Engage</strong> — this is the “do” phase of the methodology. Now that you have various “next action” lists available — some of them perhaps context-specific, e.g. “next actions to do in the office” or “next actions at home” — you can simply start working on those actions whenever you have time and mental bandwidth available for them, and you will do so in confidence, because you will know that this action is the right action to be done at that time.</li></ol><p>These steps make even more sense if you look at them in the context of <a href="http://gettingthingsdone.com/pdfs/tt_workflow_chart.pdf">this processing workflow diagram from David’s website</a>:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*6qbajzXFphT2bXfh.png" /></figure><p>A <a href="http://gettingthingsdone.com/pdfs/gtd_workflow_advanced.pdf">more advanced version of this workflow diagram is also available on his website</a>. In either case, I recommend you buy and read his book, since I can only give you a first glimpse of this method in a few paragraphs and if you want to implement this system, there is no substitute for going to the source.</p><p>The one surprising thing about the 2015 version of the GTD book is that it doesn’t talk a lot about which software tools can be adopted for the purpose of implementing such a workflow. However, I think that is absolutely key to not only implementing such methodology in the first place, but then sticking with it over time and using it to great success.</p><h3>Cloud Tools</h3><p>Since I frequently use different devices throughout my work-day — desktop computers, laptops, tablets, and smartphones — it was important for me to implement this methodology using cloud tools that I could access easily from any device. After experimenting with a variety of different solutions, I settled on a combination of the following cloud-based tools (which can be used in the browser as well as via their respective apps on smartphones and tablets). These are all available for <em>free</em> with certain capacity limitations (e.g. Google Drive is free for up to 15GB of data, and requires a subscription for larger volumes). Personally, I have a lot of data to manage, so I opted for the <a href="https://support.google.com/a/answer/6043576?hl=en&amp;ref_topic=6043375">Google Apps Unlimited</a> plan for my family, which is just $10 per user per month.</p><h3>Keep</h3><p>This first one may perhaps be a surprise to some readers. Instead of going with a traditional project-management or task organization system for organizing my to-do lists, I decided to use <a href="https://www.google.com/keep/">Google Keep</a> instead. Keep allows me to create to-do lists that can be checked off easily, notes, voice memos, and reminders — and it lets me organize these lists with labels and colors so that I can quickly focus on just those lists that I need at a given moment. For example, I use three labels to separate Work from Personal items and Investments. I also use labels to separate between Next Actions, Projects, and Incubation (for more long-term goals). So one to-do list with both labels Personal and Next Actions will tell me what my next actions are for the personal goals that I’ve defined. And Google Keep makes it very easy to filter these notes and lists by label, so I can use this multi-dimensionally to either look at all my work-related lists, or by time-horizon look at all my Incubation lists across all areas, which includes books I plan to read or things I want to learn in the next few years:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*YcjuHaunM01RRys4.png" /></figure><p>Another cool feature of Google Keep is that I can share to-do lists with family members, so we have a shared “Shopping list” in our family and whenever we run out of anything, the person who uses the last egg, the last sip of milk, the last stick of butter, simply puts that item onto the list. Then, whenever one of us goes grocery shopping, we have most of the items on the list already, and a quick WhatsApp message to the family will ask people to add any last minute thoughts, and as we go through the store we can easily check off the items as we put them into the shopping cart — even more importantly, two people can be in the store and work off the list at the same time and see respectively what the other person has checked off the list — in real time. A high-tech way of solving an age-old problem.</p><h3>Google Drive</h3><p>For all of my reference materials as well as for project plans, I decided on storing them in folders inside my <a href="https://www.google.com/drive/">Google Drive</a>. You can obviously use DropBox or any other cloud-based storage system for the same purpose. I spent a good amount of time designing a directory hierarchy that would make the system easy to use and allow me quick access to any files I need. By using Google Drive on my desktop and laptop, I can easily synchronize my files between multiple machines, and the app on my smartphone gives me access to all these files on the road. This includes all my travel plans, airline tickets, scanned copies of important documents, and anything that came out of the above GTD process for being filed as a reference material or for future incubation. It makes it really convenient to have all those files available anytime and on any device.</p><h3>Calendar</h3><p>For all of my calendar data I use <a href="http://www.google.com/calendar/about/">Google Calendar</a>. Their new app (available for both iOS and Android) is really well-designed and beautiful, and while the browser-based version is somewhat outdated in its look&amp;feel, it still gets the job done. I can again share calendar entry really easily with family members so that we can see each other’s appointments and can thus avoid conflicts.</p><h3>Inbox</h3><p>To tie it all together, if you happen to use GMail for your email system once you opt into using <a href="https://www.google.com/inbox/">Google Inbox</a>, you can now add reminders directly from Inbox, or defer emails in your inbox to a later date for future processing. It really allows you to turn this into an integrated workflow that is easy to keep up with.</p><h3>Social Media (and other distractions)</h3><p>Now that we’ve discussed the processes and tools for organizing your professional and personal projects and tasks, as well as managing your inbox, we still have to tackle one final hurdle: how to cope with the onslaught of new information that is constantly coming at you 24/7 in the form of Twitter, Facebook, news alerts, or the latest social media app you installed on your smartphone. We certainly do live in an age of distraction and our brain literally craves for every new bit of information and positive social feedback we get from every <em>like</em> and from every <em>retweet</em>. In fact, in recent years we’ve already seen <a href="http://www.albany.edu/news/56604.php">scientific articles being published on the addictive qualities of social media</a> and how it can be linked to substance abuse.</p><p>Once we understand and accept that our brain actually <em>enjoys</em> the arrival and inflow of new information, and that — very much like Pavlov’s dog — every new beep of our phones, every vibration of our smartwatches, every notification window that pops up on our screens <em>will instantly trigger a reflex and take priority</em> over whatever we currently are (or should be) doing, we can manage our time better by decisively managing and channeling these notifications.</p><p>My personal recommendations are the following:</p><ul><li>Set clearly defined times aside in your daily routine for reading the news, checking social media, and just “surfing the web”. Just like people in the “good old days” used to read the newspaper over breakfast, on the subway to work, or over lunch, you, too, can find those specific times where you will allow your brain the enjoyment of absorbing new information. I usually set aside half an hour each over breakfast and lunch, and then perhaps again after dinner, where I read my online subscriptions to the <a href="http://www.nytimes.com/">NY Times</a>, the <a href="http://www.wsj.com/">Wall Street Journal</a>, and maybe 2–3 additional articles in other publications or on blogs that may have been recommended by my friends on social media.</li><li><em>Turn off all notifications</em> from social media apps on your phone and turn off all email notifications from social media, too. You do not need your phone or smartwatch to tell you when you’ve been mentioned in a tweet or when your FB post has been shared. If you set aside specific times where you will allow yourself to check social media, then by definition during all other times you should not allow these distractions to interrupt your workflow. Ideally, go one step further and decide precisely what notifications to allow from <em>any</em> app: do you really need to see notifications about sports results, the weather, photo enhancements, or silly games that will potentially interrupt your productivity? In my case, I only allow notifications from four apps: Inbox (for personal email), MailWise (for work email), Google Calendar, and WhatsApp, which I use as our family’s designated messaging app. And remember: you can also set different ring tones for notifications from different apps, so the sound that your phone makes can tell you whether it is a text message or, personal email, or a calendar reminder — use that to your advantage.</li><li>If checking the news and social media only over breakfast and lunch feels too limiting and you think that you need to check it more often, then by all means add a 10-minute coffee break to your mid-morning routine, where you check Facebook and Twitter real quick on your way to the kitchen. However, I would rather use that time for real-world interactions with your colleagues in the office. That is usually much more productive and better for maintaining a healthy office culture.</li><li>Last, but not least, let’s talk about how often you really need to check your email inbox: that is a very personal decision and depends largely on your job, company culture, and how time-sensitive emails usually are to your day-to-day workflow. Once you’ve adopted an Inbox Zero strategy and are dealing with your inbox in a very process-oriented matter, the arrival and processing of a new email will by definition always take less than two minutes (see our discussion of the GTD process above). After that time it is either done (if it was an action requiring less than two minutes to process), delegated, deferred, filed away, deleted, or turned into a next action on one of your lists. So the real question now becomes: how much distraction from your actual work does such a 2 minute interruption cause? If you’re in the middle of programming the next big thing, writing a research paper, working on a sophisticated analysis, or otherwise need to use your full concentration, then by all means give yourself the quiet space you need, exit from your desktop email client, silence that phone for an hour or two, and put a “do not disturb” sign on your office door. You can probably do your best work if you do not allow any interruptions. If at other times you have to do a more mundane task, then it is fine to allow such interruptions. Use your best judgement to decide what level of interruption you allow to intrude at what time based on the task at hand.</li></ul><h3>TL;DR</h3><p>To summarize, I’ve found that I can implement both the <a href="http://www.43folders.com/izero">Inbox Zero</a> and <a href="http://gettingthingsdone.com/">GTD </a>methodologies nicely using a combination of <a href="https://www.google.com/keep/">Google Keep</a> and other cloud tools that make me more productive and allow me to feel more in control about both my professional and personal life and goals. Furthermore, by judiciously deciding which apps are allowed to trigger notifications on my smartphone, I can keep the onslaught of distractions under control, yet still enjoy the benefits of reading the news and being connected via social media when I take a coffee or lunch break.</p><p><em>Originally published at </em><a href="http://blog.altova.com/how-to-stay-productive-in-the-age-of-distraction/"><em>blog.altova.com</em></a><em> on October 28, 2015.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2254be4648c5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to upgrade an old MacBook Pro to Windows 10]]></title>
            <link>https://medium.com/@afalk/how-to-upgrade-an-old-macbook-pro-to-windows-10-74e28f78626b?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/74e28f78626b</guid>
            <category><![CDATA[windows-10]]></category>
            <category><![CDATA[macbook-pro]]></category>
            <category><![CDATA[mac]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Mon, 26 Oct 2015 16:52:49 GMT</pubDate>
            <atom:updated>2015-10-26T16:52:49.576Z</atom:updated>
            <content:encoded><![CDATA[<p>With the recent release of Windows 10, I embarked on a fun weekend project to convert my old MacBook Pro laptop (late 2013 model) into a new Windows 10 laptop. The process was surprisingly straight-forward, and the machine runs extremely well with all hardware features fully supported, including the high-resolution screen (“Retina display”), integrated camera (“iSight”), WiFi, Bluetooth, and all external ports. In fact, startup times, as well as time to wake from sleep, are slightly better than under MacOS, and all of the software, including Office, Adobe Creative Suite, etc., appears to perform better as well. I’m very happy with the result and this is now going to be my main laptop for all my business trips (and vacations) going forward.</p><p>You may ask why anybody would want to convert a MacBook Pro into a Windows 10 laptop in the first place. So let me explain my motivation…</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*DMxIBSN0LCiLgSp_.jpg" /></figure><h3>Background</h3><p>I’ve been using both Windows and MacOS devices essentially in parallel for the last 15+ years. For work I used mostly Windows machines and at home it was mostly Macs. And what I noticed over the past few years is that the built-in software for Mail and Calendar and Contacts in MacOS X got less useful with every iteration of the operating system from Mountain Lion (10.8) to Mavericks (10.9) to Yosemite (10.10). At the same time, the UI design got cutesier and more candy-colored — but that didn’t translate to any productivity increase for me.</p><p>Since I wasn’t using Apple’s own iCloud offering as a sole repository, the integrated MacOS apps just didn’t play well with either my office email system on an Exchange server or with my personal email on Google Apps (i.e., GMail, calendar, and contacts on own personal domain).</p><p>So I ended up mostly using my browser of choice (Chrome) to access my personal email and calendar, and using Remote Desktop to my office machine for working with my office email/calendar/contacts. For photos I had been using Lightroom instead of iPhoto for many years already, so I wasn’t tied into the iCloud/iPhoto platform. The bottom-line is that I found I hadn’t been using any MacOS-specific apps for a long time…</p><p>In terms of software that I actually use all the time, the list is fairly concise:</p><p>So I came to the conclusion that switching back and forth between using MacOS at home and Windows in the office was no longer giving me any tangible benefits. In fact, I expect this migration to produce some productivity increases due to keyboard shortcuts finally being the same across all my devices.</p><p>While I began to realize that I didn’t need to use MacOS anymore, I still wasn’t ready to give up my favorite laptop hardware. Looking at the available options for new Windows laptops, I found that they were not really superior to the laptop I already had, so I wanted to see if I could use Windows 10 on my MacBook Pro instead.</p><p>I had previously been using <a href="https://www.vmware.com/products/fusion">VMWare Fusion</a> to occasionally run Windows applications on my Mac in a virtual machine, and that had worked really well for casual usage from time to time. However, once I realized I wasn’t using any MacOS-specific software anymore, I decided to instead use <a href="https://www.apple.com/support/bootcamp/">BootCamp</a> to do a clean, native install of Windows as my primary OS on the machine.</p><p>BootCamp comes preinstalled in MacOS and allows you to partition your hard-drive and install Windows in parallel to MacOS as a native OS (rather than inside a VM). You can then decide which partition you want to boot from by default, and you can also switch the partition to boot from upon startup by holding down the “Option” key. I know of many people who divide their hard disk into equal partitions to be able to switch back and forth between MacOS and Windows as needed. However, if you need both OSs all the time, I find the VM approach to be easier to use.</p><p>For my purpose BootCamp was ideal: I decided to use Windows as my primary OS and so my goal was to partition the hard disk into a minimal MacOS partition (60GB) and use the rest of my 1TB SSD drive for Windows 10.</p><h3>Getting started</h3><p><em>Before you do anything else, make sure you have a complete </em><strong><em>backup</em></strong><em> of all your data. This process is potentially </em><strong><em>destructive</em></strong><em> to all the data on your hard disk!</em></p><p>So here are all the ingredients you will need for this upgrade process:</p><ul><li>An old MacBook laptop (mine was a Pro with Retina display from 2013, but this same process should work fine for any 2009 or younger MacBook Pro or Air)</li><li>A <a href="http://www.microsoftstore.com/store/msusa/en_US/pdp/Windows-10-Pro/productID.319935900">Windows 10 license &amp; product-key</a>, which you can buy directly from the Microsoft Store</li><li>A USB flash drive with at least 4GB capacity</li><li>A large empty external USB hard drive, if you want to preserve a large amount of data from your old Mac hard disk and then copy it on your new Windows hard disk later</li></ul><p>Please note that I actually did a 2-step upgrade process, because I began the migration a week before the final version of Windows 10 was released. So I bought and installed Windows 8.1 first and then upgraded to Windows 10 (for free) a week later. But you can do the exact same process straight to Windows 10 now by buying and installing a Windows 10 license directly.</p><p><em>Did I already mention that you should make a complete </em><strong><em>backup</em></strong><em> of all your data before proceeding?</em></p><h3>The upgrade process</h3><p>Here’s the sequence of actions to upgrade your MacBook Pro laptop to become a Window 10 machine:</p><p>1. If you want to move a large amount of data from your old Mac laptop to your new Windows machine:</p><ul><li>You could either use Google Drive or DropBox or some other cloud provider to sync the data from one machine to the other (if you have a fast Internet connection).</li><li>Or you could use an external USB hard drive. In this case, the important thing to do is to make sure that the external USB disk is formatted in the ExFAT file system, since that is the only file system that can be read/written to properly by both MacOS and Windows. Do not format it as HFS+ (Mac only) or NTFS (Windows only). On the Mac you can use Disk Utility to format the USB drive as ExFAT, or you can also do the same on a separate Windows PC. Once you have made sure the drive is ExFAT, copy all your files from the Mac hard disk to the external drive.</li></ul><p>2. Once all your data is secured, disconnect the external drive and put it away in a safe spot (or uninstall the cloud provider software). It is now time to clean up your Mac to minimize the disk space that the small MacOS partition will occupy in the future.</p><ul><li>You can either do that by starting from the Recovery partition on your Mac (hold down Command-R while your Mac boots) and then reinstalling MacOS from scratch and formatting the drive in the process. <strong>WARNING</strong>: This is <strong>destructive</strong> to all the data on your disk. Make sure you have a <strong>backup</strong>!</li><li>Or you can use an app like <a href="http://www.daisydiskapp.com/">DaisyDisk</a> to identify what is using a large amount of space on your Mac and delete it from there. That, too, is destructive to your data, so make sure you have a backup!</li></ul><p>3. Even though you are trying to minimize the future size of your Mac partition, don’t actually try to repartition the drive manually. Instead, you want the full drive to be assigned to one Mac partition and you will later repartition it using the BootCamp Assistant as part of the installation process.</p><p>4. When you are happy with the amount of space that MacOS now occupies, it is necessary to <em>ensure that you’ve upgraded your MacOS to Yosemite (10.10)</em> and have installed all the latest updates and security patches. I’ve found that the BootCamp version that is included with Mavericks (10.9) will <em>not</em> accept the Windows 10 installation disk and will not work. You have to first upgrade your MacOS to Yosemite before you proceed, which happens to be a free upgrade.</p><p>5. Next <a href="http://www.microsoftstore.com/store/msusa/en_US/pdp/Windows-10-Pro/productID.319935900">purchase a Windows 10 license from the Microsoft Store</a> and download the installation media. You will need to do that on a separate Windows machine, as the download from the Microsoft Store is a program called “MediaCreationTool”, which will in turn download the actual OS image and help you create the right installation media. Now it depends on whether you Mac has a CD/DVD drive or not. If you have a drive, you can simply use the MediaCreationTool to burn an installation disk. Otherwise, use it to create an ISO disk image file. If you are using an ISO disk image file, use the USB flash drive, your external USB hard drive, or a network drive to copy the ISO disk image to your Mac and put it somewhere in your Documents folder.</p><p>6. Now it is time to actually <a href="https://support.apple.com/en-us/HT201468">install Windows using Boot Camp</a>. To do so, open the Boot Camp Assistant, which you can find in the Utilities folder under Applications.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*rNaPIUh9TJx4oJd7.png" /></figure><p>The information available about the necessary installation steps on the Apple website is only the most basic sequence of events, so I recommend that you continue following the steps I’ve outlined here instead.</p><p>7. Leave all the checkboxes in BootCamp Assistant turned on (i.e., allow it to download the latest Windows drivers for your hardware). BootCamp Assistant will then ask you to plug in a USB drive (which is where it will store those drivers for later installing them after the main Windows installation has completed).</p><p>8. The software will then allow you to decide how much space to allocate to Windows and how much space to allocate to the MacOS partition.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*8KIoP22F8DKt2QOX.png" /></figure><p>In my case I dragged the slider all the way to the left to give MacOS only 60GB and have 940GB available for Windows. Your specific requirements may be different, so pick a size that most closely matches how much time you expect to spend in each OS.</p><p>9. Once you click the “Partition” button, your Mac partition will be resized and a new partition will be created for Windows.</p><ul><li>There is a small caveat here — other people have reported not being able to resize their MacOS paritions under Yosemite, and I’ve had a similar issue in DiskUtility in the past. This can potentially be related to the Core Storage file system virtualization layer under Yosemite. If you run into a problem at this step or whenever you try to resize a partition under Yosemite, check out <a href="http://awesometoast.com/yosemite-core-storage-and-partition-woes/">this blog post</a> and follow the instructions there to revert from Core Storage to a regular partition table.</li></ul><p>10. Next the BootCamp Assistant may end up asking you to either insert the Windows installation media (if you have a DVD drive) or will ask you to locate the IOS image file that you copied to your hard disk earlier.</p><p>11. Now all the pieces are in place for the actual Windows 10 installer to take over. Your computer will reboot several times throughout the process.</p><p>12. In the first cycle, you will get the familiar Windows setup screen that lest you pick an installation language and keyboard.</p><p>13. Next you will need to decide which partition you want to install Windows into. This is an extremely important step — make sure you find the partition named BOOTCAMP in the list, select it, and then click the “Format” button underneath the list. Once formatting is completed, the “Next” button will become enabled and you click that to proceed with installing into the new partition you created in step 9 above.</p><p>14. Now let the Windows 10 installer run through, including 2 potential reboots of the machine. Once you are logged into Windows 10 after the entire Windows 10 installation sequence has completed, another installer should pop up for installing device drivers from the UBS stick. These are Windows-drivers from Apple that are specific to the particular hardware of your Mac. Make sure you install these! If the installer doesn’t start on its own, go to the USB drive and launch the setup.exe you will find there.</p><p>15. Sometimes you may find that the screen resolution is not yet optimal at this point and you may need to do one more restart for all the Windows drivers to load correctly.</p><p>16. Voilà! At this point you should have a clean install of a Windows 10 laptop in front of you and are ready to install whichever software you need on it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*xxpgZha2WZdEsHsK.jpg" /></figure><p>17. You can now also reconnect your external USB hard disk to copy all the necessary data files to your Windows partition. Since you formatted that hard drive in ExFAT it should be nicely readable from Windows.</p><p>18. Last, but not least, I found the original Apple-supplied Windows driver for the trackpad on my MacBook Pro to not be as responsive and configurable as I would want. I found a 3rdparty driver for the Trackpad that works much better — it is called <a href="http://trackpad.powerplan7.com/">Trackpad++</a>.</p><h3>Conclusion</h3><p>While the installation process might seem a bit daunting at first, it is actually pretty smooth sailing once you know what to do. And the performance of the laptop with a fresh clean OS install is just wonderful. Windows 10 has essentially rejuvenated my laptop! Prior to this upgrade adventure I had also looked at various potential Windows laptop hardware from different manufacturers, and I found the MacBook Pro hardware to actually be superior to many Windows laptops being offered today, both in terms of performance to weight ratio, battery life, screen resolution, sturdiness of the case, and other factors.</p><p>The only thing I dearly miss on my new Windows 10 laptop is an actual “Delete” key on the keyboard. In true Apple purity the MacBook Pro keyboard only has a “Backspace” key…</p><p>Since this process worked so well on the old laptop, I’ve now begun the next project and am in the process of trying to also breathe some new life into my old Mac Pro tower, which is my main home office machine — and essentially my main photo editing station — and is a mid-2010 aluminum tower model with a 12-core Intel Xeon X5670 CPU running at 2.93GHz, 32GB of RAM, and an ATI Radeon HD 5800 graphics card, so the CPU and RAM are still highly performant and totally adequate for my average workload. I had previously posted (on my old blog) about <a href="http://www.xmlaficionado.com/2014/09/computer-brain-surgery-or-how-to.html">removing the old Apple RAID card</a> from that machine in 2014, so it already has a SSD drive as its primary boot disk. As you can see, I’m not afraid to tinker with hardware…</p><p>For this new project I have already installed Windows 10 on it (this time as a direct install rather than via a Windows 8.1 detour mentioned above) and it is working beautifully. As a next step I now have a <a href="http://www.amazon.com/Express-Graphics-outperforms-Sapphire-Gigabyte/dp/B01010EE0U/ref=sr_1_5?ie=UTF8&amp;qid=1438610308&amp;sr=8-5&amp;keywords=graphics+card+mac+pro">new graphics card</a> on order and will also be adding <a href="http://www.sonnettech.com/product/allegroprousb3pcie.html">USB 3.0 ports</a> to that machine to make it compatible with various external USB 3.0 hard disks.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*HC2F4UkLuNlAlhr1.jpg" /></figure><p>The bottom-line is that Windows 10 performs beautifully on Apple hardware, such as the MacBook Pro or the old Mac Pro and can give a new life to these old machines. Of course, I’m not trying to tell you that Windows is better than MacOS. That is always a very personal choice, and if you like working with MacOS or are used to a lot of MacOS-specific applications, such as iPhoto, GarageBand, etc., or are tied into the iCloud ecosystem, then keeping these machines running on Yosemite might be the right thing for you.</p><p>But if you’re in a similar situation as I was, where you find yourself switching between Windows and MacOS machines all the time, and you are not actually using any MacOS-specific apps anymore or you just long for a unified UI experience, then installing Windows 10 on your old Apple hardware might work really well for you.</p><p><em>Originally published at </em><a href="http://blog.altova.com/how-to-upgrade-an-old-macbook-pro-to-windows-10/"><em>blog.altova.com</em></a><em> on August 4, 2015.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=74e28f78626b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[XBRL Data Quality of SEC Filings]]></title>
            <link>https://medium.com/@afalk/xbrl-data-quality-of-sec-filings-a13839b69811?source=rss-98e069f1a47e------2</link>
            <guid isPermaLink="false">https://medium.com/p/a13839b69811</guid>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[xbrl]]></category>
            <category><![CDATA[accounting]]></category>
            <dc:creator><![CDATA[Alexander Falk]]></dc:creator>
            <pubDate>Mon, 26 Oct 2015 15:46:40 GMT</pubDate>
            <atom:updated>2015-10-26T15:46:40.636Z</atom:updated>
            <content:encoded><![CDATA[<p>For fundamental investors probably the most important financial information to study are the financial reports from companies that they wish to potentially invest in. For publicly traded companies in the US, the <a href="http://www.sec.gov/">SEC</a> regulates what data needs to be reported and at which frequency, and investors typically access those financial reports through their own brokerage firm’s website, or through publicly available databases from other Internet providers. In addition, all the original filings from all companies are also directly available from the SEC in the <a href="http://www.sec.gov/edgar/searchedgar/companysearch.html">EDGAR database</a>. In addition to HTML and PDF versions of those financial reports, the EDGAR database also contains XBRL versions of those company filings since 2007, with the <em>intent</em> of making this data more easily comparable and directly consumable by computer programs for further analysis.</p><p>At least that is the goal…</p><p>In this article we’re going to look at some issues with the XBRL data quality of company filings in the SEC’s EDGAR database and show the surprising lack of correlation of high-level financial data extracted from the XBRL filings with publicly available financial data about US companies provided, e.g., by <a href="http://finance.yahoo.com/">Yahoo Finance</a>, <a href="https://www.google.com/finance">Google Finance</a>, and <a href="https://eresearch.fidelity.com/eresearch/landing.jhtml">Fidelity Investments</a>, as well as the shocking discrepancies found in the data reported by those separate services amongst one another.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*2OLpXcnJtcEupEtl.jpg" /></figure><p>Given how important these financial reports are for investors, one would assume that the financial data available on the various websites is close to 99% accurate and matches the actual company filing in XBRL format. However, that does not seem to be the case at all.</p><p>We have run a detailed comparison of the balance sheet data as reported on the the Google Finance, Yahoo Finance, and Fidelity Investments web pages. Those three services were randomly picked and we’re pretty confident that we would have found similar discrepancies had we picked three other services. For our test we have compared the recent quarterly filings from about 6,700 companies with ticker symbols in their XBRL filings to ensure a 100% correct match between CIK# — the identifier the SEC uses internally in the EDGAR database — and the more well-known stock ticker symbols.</p><p>As all these companies report their balance sheet data with slightly different breakdowns (more on that later in this post), we had to summarize the detail line items to make them comparable. We have also rounded the numbers to the nearest million if they were bigger than a million, otherwise to the nearest thousand.</p><h3>Correlation between financial services</h3><p>Below is a table showing for each high-level line item on the balance sheet what percentage of company filings the three web sites reported the exact same number (column “All agree”). As you can see, for some major line items like <em>Total Current Assets</em>, <em>Total Assets</em>, and <em>Total Current Liabilities</em> the three web sites do indeed agree for 94% or more of the companies. But if you look at A/R and A/P data in <em>Receivables</em> or <em>Accounts Payable</em>, they only agree in 35% and 2.4% of the cases respectively. That should be of great concern to any investor!</p><p>The second column is also interesting, because it shows the percentage of companies in our sample where all three services disagree and report completely different data.</p><p>Last, but not least, the remaining three columns show the percentage where two providers had the same value but the third one had a different result in their report. Please also note that this table doesn’t actually say anything about which data provider is more correct, just the number of times they agree/disagree.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/966/0*h9IElmml03Q-y2R7.png" /></figure><p>As mentioned above the major line items containing the totals on the assets and liabilities side of the balance sheet are usually fairly accurate and correlate well between the providers, as these are commonly reported directly in the corporate filing. But there is a lot of ambiguity for some of the more detailed line item breakdowns.</p><p>Also we’ve identified many cases where even the major totals such as <em>Total Liabilities</em> report numbers that may seem to be in the right ballpark, but the difference can still be <em>an error of a few million or billion</em> — sometimes even due to obvious typos resulting from manual data entry, such as some providers reporting <em>Total Liabilities</em> for SWC for 2014–12–31 as 468,000,000 vs. 486,000,000.</p><h3>Correlation of XBRL data and services</h3><p>The actual breakdown of the major concepts like Assets into its constituent parts often differs quite dramatically. Here is a quick illustration using GE’s quarterly balance sheet from 2015–06–30. We have compared the Assets part of the official 10-Q balance sheet (left side) to the data on Google/Yahoo/Fidelity respectively (right side) and will discuss notable differences as well as show the mapping probably undertaken by these services, as far as we can deduce it:</p><h4>Google Finance</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*yrI-GgnqthddOkkq.png" /></figure><p>One striking issue is that Google didn’t include all line items from the original balance sheet (see red bar and question marks on the left side) and thus <em>the Google-reported</em> <em>line items don’t actually add up to their Total Assets sum</em>! Also note that GE doesn’t provide an explicit current/non-current breakdown in their filing, but usually the more current assets are listed first in XBRL filings based on US-GAAP. However, it appears that Google has mapped the Investment securities line item into Long Term Investments.</p><p>One other interesting fact is that instead of reporting Property, plant, and equipment as a net number on the balance sheet, like the XBRL filing on the left shows, Google is providing a separation of gross property/plant/equipment minus depreciation, so more data than is actually reported in the XBRL balance sheet. The data for this breakdown is provided in Note 6 of the XBRL filing, but only in text form and not as XBRL facts, so it cannot be extracted from the XBRL file automatically and instead requires manual data entry by a human operator.</p><h4>Yahoo Finance</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2MTtUEA2molpeyik.png" /></figure><p>Interestingly, Yahoo’s mapping from the official XBRL balance sheet to their representation seems to be quite logical and straightforward. The only exception is <em>Assets of businesses held for sale</em> which Yahoo has decided to add to <em>Property/Plant/Equipment</em> rather than <em>Other Assets</em>. However, in the grand scheme of things, that seems to be a minor distinction. At least their numbers add up and the balance sheet corresponds mostly to the XBRL balance sheet.</p><h4>Fidelity Investments</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/977/0*-FMdJxhfGl8XCttj.png" /></figure><p>Here the most striking feature is that only 5,596 of the <em>Investment securities</em> was attributed to <em>Short-Term Investments</em>, the remainder of 33,842 to <em>Other Non-current Assets</em>. There is nothing in the XBRL filing — not even in the Notes — that would hint at why this breakdown would be appropriate. Also <em>Goodwill</em> and other intangible assets were added to <em>Other Non-current Assets</em> instead of correctly showing them under <em>Intangible Assets</em>. In fact, the <em>Other Non-current Assets</em> line item appears to be a bit of catch-all in the balance sheet numbers shown by Fidelity.</p><p>As the above comparison has shown, Google’s data seems not reliable overall as their line items don’t even add up correctly to the totals given. Fidelity’s breakdown is not apparent and difficult to understand sometimes, and several items seem to simply be lumped together into the various “Other” line items rather than mapped exactly. From the perspective of correlation with XBRL company filings, Yahoo’s mapping appears to be the most straightforward and recognizable correlation.</p><p>If you would like to reference the source data used in this correlation, here are the links to the respective web sites and the exact pages references in the above diagrams:</p><h3>Analysis of XBRL Data Quality Issues</h3><p>So the question arises: why is it so difficult to map all this financial data from XBRL into a high-level presentation that an investor can use to make good decisions? Wasn’t XBRL supposed to provide a reliable machine-readable form of the financial reports that could be used to better understand company filings?</p><p>In our experience with processing and analyzing all XBRL filings over the last several years, we’ve identified five major hurdles that make it extremely difficult to automatically process/extract data from the SEC XBRL company filings in the EDGAR database.</p><h4>1. No standard mechanism to identify linkrole for a given report in extension taxonomies</h4><p>There is no predefined linkrole for the balance sheet report and every company makes up a slightly different name. For example, here are just a few of the thousands of distinct linkrole endings:</p><p><em>‘ConsolidatedBalanceSheets’,’BalanceSheets’,’StatementOfFinancialPositionClassified’,’CondensedConsolidatedBalanceSheets’,’StatementConsolidatedBalanceSheets’,’StatementConsolidatedBalanceSheet’,’ConsolidatedBalanceSheet’,’StatementCondensedConsolidatedBalanceSheets’,’CondensedConsolidatedBalanceSheetsUnaudited’,’ConsolidatedBalanceSheetsUnaudited’,’BalanceSheet’,’BalanceSheetsUnaudited’,’CondensedBalanceSheets’,’StatementCONSOLIDATEDBALANCESHEETS’,’StatementCONSOLIDATEDBALANCESHEET’,’idr_BalanceSheets’,’idr_CONSOLIDATEDBALANCESHEETS’,’ConsolidatedStatementsOfFinancialCondition’,’StatementBalanceSheets’,’idr_ConsolidatedBalanceSheets’,’ConsolidatedCondensedBalanceSheets’,’ConsolidatedStatementsOfFinancialPosition’,’idr_BALANCESHEETS’,’UnauditedCondensedConsolidatedBalanceSheets’,’StatementCondensedBalanceSheets’,’StatementConsolidatedStatementsOfFinancialCondition’,’CondensedConsolidatedBalanceSheet’,’StatementCONDENSEDCONSOLIDATEDBALANCESHEETS’,’idr_StatementOfFinancialPosition’,’idr_CONDENSEDCONSOLIDATEDBALANCESHEETS’,’StatementsOfFinancialCondition’,’StatementCONDENSEDBALANCESHEETS’,’UnauditedConsolidatedBalanceSheets’,’idr_CondensedBalanceSheets’,’CondensedBalanceSheetsUnaudited’,’CondensedBalanceSheetsTable’,’CONSOLIDATEDBALANCESHEETS’,’idr_BalanceSheet’,’statement-condensed-consolidated-balance-sheets-current-period-unaudited’,’StatementOfFinancialPosition’,’CondensedConsolidatedBalanceSheetUnaudited’,’CondensedBalanceSheet’,’StatementCONDENSEDCONSOLIDATEDBALANCESHEETSUnaudited’,’StatementConsolidatedStatementsOfFinancialPosition’,’idr_BalanceSheetsUnaudited’,’CondensedConsolidatedStatementsOfFinancialPosition’,’StatementBALANCESHEETS’,’idr_CONSOLIDATEDBALANCESHEETSUnaudited’,’StatementConsolidatedCondensedBalanceSheets’,’StatementsOfFinancialConditionUnaudited’,’StatementConsolidatedBalanceSheetsUnaudited’,’CondensedStatementsOfFinancialCondition’,’idr_CondensedConsolidatedBalanceSheets’,’ConsolidatedStatementsOfFinancialConditionUnaudited’,’Consolidatedbalancesheets’,’idr_CONDENSEDBALANCESHEETS’,’ConsolidatedCondensedBalanceSheetsUnaudited’,’StatementCondensedConsolidatedBalanceSheetsUnaudited’,’ConsolidatedBalanceSheetUnaudited’,’CondensedConsolidatedStatementsOfFinancialCondition’,’ConsolidatedStatementsOfCondition’,’StatementStatementsOfFinancialCondition’</em></p><p>In reality one needs to implement a sophisticated string matching heuristics algorithm and include the roleType definition string, which yields slightly less variation, e.g., searching for the words ‘Balance’ and ‘Sheet’. This is obviously not 100% reliable and one also has to deal with spelling errors in the linkroles, e.g., “Sheeets”.</p><h4>2. Calculation linkbases are typically too flat in extension taxonomies</h4><p>The companies typically provide only a breakdown of the top level concepts like Assets or Liabilities, and maybe an additional breakdown for Current/Non-current Assets/Liabilities, but they don’t provide enough detail to know how to compute the other important balance sheet line items, such as Accounts Receivable, Prepaid Expenses, etc.</p><p>This is especially problematic when custom concepts are included in an extension taxonomy that are then not properly included in the calculation linkbase of said extension taxonomy. For example, here is an excerpt of the calculation linkbase from GE’s filing that we used in the above mappings:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/538/0*3KRCMOi51x16YZCP.png" /></figure><h4>3. US-GAAP standard calculation linkbase often not applicable</h4><p>The US-GAAP taxonomy provides templates for the balance sheet calculation linkbase which have a very detailed and deep breakdown of Assets and Liabilities. This would be perfect for our purposes as their breakdown often matches well with the line items that we as investors are interested in.</p><p>Unfortunately, however, the standard calculation linkbase cannot be reliably applied to all XBRL filings because (a) standard concepts are not used consistently, (b) sometimes the extension calculation linkbase redefines this hierarchy, and (c) the standard calculation linkbase doesn’t help with additional custom concepts introduced in extension taxonomies.</p><p>Below are just a few small excerpts from the standard calculation linkbase annotated with the line items in the Yahoo Finance website reports that these concepts were added to respectively. This is an example from the Liabilities side of the balance sheet report:</p><pre>Liabilities LiabilitiesCurrent AccountsPayableAndAccruedLiabilitiesCurrent x1267 Accounts Payable, x4 Other Current Liabilities, x2 Short/Current Long Term Debt AccruedLiabilitiesCurrent x5042 Accounts Payable, x21 Other Current Liabilities, x7 Short/Current Long Term Debt, x1 Other Liabilities AccruedAdvertisingCurrent x33 Accounts Payable AccruedInsuranceCurrent x51 Accounts Payable AccruedLiabilitiesForUnredeeemedGiftCards x18 Other Current Liabilities AccruedMarketingCostsCurrent x45 Accounts Payable AccruedProfessionalFeesCurrent x19 Accounts Payable, x4 Other Current Liabilities AccruedRentCurrent x14 Accounts Payable, x2 Short/Current Long Term Debt AccruedRoyaltiesCurrent x96 Accounts Payable, x8 Other Current Liabilities, x4 Short/Current Long Term Debt AccruedSalesCommissionCurrent x30 Short/Current Long Term Debt, x25 Accounts Payable, x4 Other Liabilities AccruedUtilitiesCurrent x3 Accounts Payable LeaseIncentivePayableCurrent x5 Other Current Liabilities, x3 Short/Current Long Term Debt OtherAccruedLiabilitiesCurrent x996 Accounts Payable, x69 Other Current Liabilities, x8 Short/Current Long Term Debt ProductWarrantyAccrualClassifiedCurrent x119 Accounts Payable, x56 Other Current Liabilities StandardProductWarrantyAccrualCurrent x15 Accounts Payable, x8 Other Current Liabilities</pre><p>As an illustrative example, take a look at the <em>AccruedSalesCommissionCurrent</em> concept, which was added to Short/Current Long Term Debt in 30 filings, Accounts Payable in 25 filings and to Other Liabilities in 4 filings. Looking at the numbers above, the concepts under <em>AcrruedLiabilitiesCurrent</em> are usually added to Accounts Payable, but not always. Also there are a lot of concepts that have a distinction between current and non-current. The parent concept is supposed to contain the total sum but in practice is often used instead of one or the other, e.g.:</p><pre>SecuredDebt x57 Long Term Debt, x12 Short/Current Long Term Debt, x2 Other Current Liabilities, x1 Other Liabilities SecuredDebtCurrent x22 Short/Current Long Term Debt, x5 Other Current Liabilities SecuredLongTermDebt x36 Long Term Debt, x4 Other Liabilities</pre><pre>OtherLiabilities x93 Other Liabilities, x11 Accounts Payable, x5 Other Current Liabilities, x3 Deferred Long Term Liability Charges OtherLiabilitiesCurrent x596 Other Current Liabilities, x125 Accounts Payable, x13 Short/Current Long Term Debt, x5 Other Liabilities OtherLiabilitiesNoncurrent x1916 Other Liabilities, x27 Deferred Long Term Liability Charges, x8 Long Term Debt, x1 Other Stockholder Equity</pre><p>As you can see, extracting reliable high-level financial report data that is useful to investors and that can easily be utilized for comparative analysis between multiple companies is very difficult even today.</p><h4>4. The real information is in the labels</h4><p>The sad truth is — and this brings us back to the headline of this post — that even though XBRL financial reports have been mandated for many years now, a lot of public companies still see it as an after-thought and simply take their HTML filings and produce the XBRL instance by quick&amp;dirty tagging of the numbers with one of the standard concepts from the US-GAAP taxonomy using one of the many tagging solutions on the market. If not enough care is taken to pick out the most applicable concept out of the 15k predefined concepts, then the data quality of the resulting XBRL suffers immensely and the usefulness of the data to an investor becomes questionable. In our experience, extracting information with rules using only concept names cannot be 100% reliable. One would need to parse/analyze the concept labels (which are copied from the original HTML), which leads the whole idea of taxonomies and calculation linkbase ad absurdum. Here are a few such examples which are impossible to map to the correct high-level financial line item just from the concept name:</p><p><strong>Concept</strong> <strong>Label</strong> <strong>High-level line item (on Yahoo)</strong> us-gaap:OtherAssetsNoncurrent Investments and sundry assets Long Term Investments us-gaap:OtherLiabilitiesCurrent Other accrued expenses and liabilities Accounts Payable</p><h4>5. Too many custom concepts</h4><p>The list below shows all the concepts that were involved (in at least one filing) in calculating the <em>Cash And Cash Equivalents</em> line item (extracted from matching facts) and in how many company filings this concept was encountered just in 2015. The concepts without namespace are predefined standard US-GAAP concepts; the concepts with namespaces are company extension taxonomy concepts we encountered. Please note that this list is not fully complete and also varies from year to year and one software version to the next of the tagging solutions that are being used by companies:</p><pre>Cash And Cash Equivalents CashAndCashEquivalentsAtCarryingValue 10189 RestrictedCashAndCashEquivalentsAtCarryingValue 1241 RestrictedCashAndCashEquivalents 643 Cash 417 RestrictedCashAndInvestmentsCurrent 180 CashEquivalentsAtCarryingValue 43 RestrictedInvestmentsCurrent 29 CashAndCashEquivalentsAtCarryingValueIncludingDiscontinuedOperations 21 EquityMethodInvestments 20 RestrictedCashAndInvestments 17 AvailableForSaleSecurities 15 FundsHeldForClients 13 FinancialInstrumentsOwnedMortgagesMortgageBackedAndAssetBackedSecuritiesAtFairValue 12 InterestBearingDepositsInBanks 12 CashAndDueFromBanks 11 CashAndSecuritiesSegregatedUnderFederalAndOtherRegulations 10 MarginDepositAssets 10 FederalHomeLoanBankStock 8 CashCollateralForBorrowedSecurities 7 DepositsAssets 7 DepositsAssetsCurrent 6 CashAndCashEquivalentsFairValueDisclosure 6 CertificatesOfDepositAtCarryingValue 6 MarketableSecuritiesRestrictedCurrent 5 EscrowDeposit 5 RestrictedCashAndCashEquivalentsNoncurrent 4 DepositAssets 4 RestrictedInvestmentsNoncurrent 4 MortgageLoansOnRealEstateCommercialAndConsumerNet 4 SecuritiesForReverseRepurchaseAgreements 4 HeldToMaturitySecuritiesRestricted 4 CashCashEquivalentsAndFederalFundsSold 4 HeldtomaturitySecuritiesRestrictedCurrent 4 AvailableForSaleSecuritiesRestricted 3 ServicingAssetAtFairValueAmount 3 DerivativeAssetsCurrent 3 OtherRestrictedAssetsCurrent 3 CarryingValueOfFederalFundsSoldSecuritiesPurchasedUnderAgreementsToResellAndDepositsPaidForSecuritiesBorrowed 3 PrepaidExpenseAndOtherAssetsCurrent 3 MarketableSecuritiesEquitySecurities 3 ReplacementReserveEscrow 3 EarnestMoneyDeposits 3 RestrictedInvestments 2 AvailableForSaleSecuritiesDebtSecuritiesNoncurrent 2 AvailableForSaleSecuritiesPledgedAsCollateral 2 FinancialInstrumentsOwnedStateAndMunicipalGovernmentObligationsAtFairValue 2 AssetsHeldInTrustNoncurrent 2 OtherRestrictedAssets 2 TradingSecuritiesPledgedAsCollateral 2 ShortTermInvestments 1 HeldToMaturitySecurities 1 PledgedAssetsSeparatelyReportedMortgageRelatedSecuritiesAvailableForSaleOrHeldForInvestment 1 USGovernmentSecuritiesAtCarryingValue 1 MortgageBackedSecuritiesAvailableForSaleFairValueDisclosure 1 {http://www.voya.com/20140930}:CashAndCashEquivalentsConsolidatedInvestmentEntities 2 {http://www.copt.com/20140930}:RestrictedCashAndMarketableSecurities 1 {http://www.carlyle.com/20140630}:RestrictedCashAndCashEquivalentsAndSecuritiesOfConsolidatedFunds 1 {http://www.virtus.com/20141231}:CashPledgedOrOnDepositOfConsolidatedSponsoredInvestmentProducts 1 {http://www.intgla.com/20150331}:RestrickedCashMortgageImpounds 1 {http://www.dunkinbrands.com/20150328}:RestrictedAssetsOfAdvertisingFunds 1 {http://www.intgla.com/20141231}:RestrictedCashRedemption 1 {http://www.carlyle.com/20150331}:RestrictedCashAndCashEquivalentsAndSecuritiesOfConsolidatedFunds 1 {http://www.kkr.com/20140930}:CashAndCashEquivalentsHeldAtConsolidatedEntities 1 {http://www.intgla.com/20140630}:RestrictedCashRedemption 1 {http://www.nelnet.com/20140630}:CashAndCashEquivalentsNotHeldAtRelatedParty 1 {http://www.lazard.com/20141231}:DepositsWithBanksAndShortTermInvestments 1 {http://www.aecom.com/20140930}:CashAndCashEquivalentsGeneral 1 {http://www.dstsystems.com/20140930}:RestrictedCashAndCashEquivalentsAtCarryingValueOnBehalfOfClients 1 {http://www.vaalco.com/20140630}:FundsInEscrowCurrent 1 {http://igt.com/20140930}:RestrictedCashAndInvestmentSecuritiesOfVIEs 1 {http://www.linkp.com/20141231}:CashAndCashEquivalentsExcludingCertificatesOfDeposit 1 {http://www.nelnet.com/20141231}:CashAndCashEquivalentsRelatedParty 1 {http://www.anworth.com/20140630}:AgencyMortgageBackedSecuritiesAtFairValue 1 {http://www.eatonvance.com/20150131}:CashAndCashEquivalentsConsolidatedVariableInterestEntity 1 {http://www.wendys.com/20141228}:AdvertisingFundsRestrictedAssets 1 {http://www.invesco.com/20150630}:CashAndCashEquivalentsOfConsolidatedInvestmentProducts 1 {http://www.dunkinbrands.com/20140628}:RestrictedAssetsOfAdvertisingFunds 1 {http://corp.sohu.com/20141231}:RestrictedTimeDepositsCurrent 1 {http://www.dstsystems.com/20140630}:RestrictedCashAndCashEquivalentsAtCarryingValueOnBehalfOfClients 1 {http://www.firstmarblehead.com/20140930}:DepositsForParticipationInterestAccounts 1 {http://www.nelnet.com/20150331}:CashAndCashEquivalentsNotHeldAtRelatedParty 1 {http://www.orchidislandcapital.com/20140930}:MortgageBackedSecuritiesAtFairValueUnpledged 1 {http://www.orm.com/20140930}:CashAndCashEquivalentsAtCarryingValueFundCompany 1 {http://www.virtus.com/20150331}:CashPledgedOrOnDepositOfConsolidatedSponsoredInvestmentProducts 1 {http://www.kennedywilson.com/20140630}:CashHeldbyConsolidatedInvestments 1 {http://www.ultrapetroleum.com/20150331}:RestrictedCash 1 {http://www.pnkinc.com/20141231}:CashandCashEquivalentsExcludingDiscontinuedOperations 1 {http://www.copt.com/20150331}:RestrictedCashAndMarketableSecurities 1 {http://www.orchidislandcapital.com/20150630}:MortgageBackedSecuritiesAtFairValuePledgedAsCollateral 1 {http://www.orm.com/20141231}:CashAndCashEquivalentsAtCarryingValueParent 1 {http://www.lazard.com/20150331}:DepositsWithBanksAndShortTermInvestments 1 {http://www.nelnet.com/20141231}:CashAndCashEquivalentsNotHeldAtRelatedParty 1 {http://www.virtus.com/20150630}:CashAndCashEquivalentsOfConsolidatedSponsoredInvestmentProducts 1 {http://www.orchidislandcapital.com/20140930}:MortgageBackedSecuritiesAtFairValuePledgedAsCollateral 1 {http://www.kennedywilson.com/20140930}:CashHeldbyConsolidatedInvestments 1 {http://www.zionoil.com/20140930}:DepositsAssetsRestrictedCurrent 1 {http://www.anworth.com/20141231}:AgencyMortgageBackedSecuritiesAtFairValue 1 {http://www.orchidislandcapital.com/20150331}:MortgageBackedSecuritiesAtFairValueUnpledged 1 {http://www.orm.com/20140930}:CashAndCashEquivalentsAtCarryingValueParent 1 {http://www.kennedywilson.com/20140930}:CashandCashEquivalentsExcludingCashHeldbyConsolidatedInvestments 1 {http://www.nwbio.com/20140630}:CashInCustodyAccount 1 {http://www.kennedywilson.com/20150331}:CashandCashEquivalentsExcludingCashHeldbyConsolidatedInvestments 1 {http://www.qtww.com/20150331}:CashAndCashEquivalentsOfContinuingOperationsAtCarryingValue 1 {http://burlingtoncg.com/20150331}:AvailableForSaleSecuritiesFairValueDisclosureMortgageBackedSecurities 1 {http://www.sunedison.com/20141231}:CashCommittedforConstructionProjects 1 {http://burlingtoncg.com/20140930}:AvailableForSaleSecuritiesFairValueDisclosureMortgageBackedSecurities 1 {http://www.nelnet.com/20140630}:CashAndCashEquivalentsRelatedParty 1 {http://www.sunedison.com/20140930}:CashCommittedforConstructionProjects 1 {http://www.orm.com/20150331}:CashAndCashEquivalentsAtCarryingValueFundCompany 1 {http://www.wendysarbys.com/20140629}:AdvertisingFundsRestrictedAssets 1 {http://www.cnoinc.com/20150331}:CashAndCashEquivalentsHeldByVariableInterestEntities 1 {http://www.ultrapetroleum.com/20150630}:RestrictedCash 1 {http://www.intgla.com/20140630}:RestrickedCashMortgageImpounds 1 {http://www.cnoinc.com/20140930}:CashAndCashEquivalentsHeldByVariableInterestEntities 1 {http://www.kkr.com/20150331}:CashAndCashEquivalentsHeldAtConsolidatedEntities 1 {http://www.kennedywilson.com/20150331}:CashHeldbyConsolidatedInvestments 1 {http://www.kennedywilson.com/20141231}:CashandCashEquivalentsExcludingCashHeldbyConsolidatedInvestments 1 {http://www.virtus.com/20150630}:CashPledgedOrOnDepositOfConsolidatedSponsoredInvestmentProducts 1 {http://www.intgla.com/20140930}:RestrickedCashMortgageImpounds 1 {http://www.aircastle.com/20150331}:RestrictedLiquidityFacilityCollateral 1 {http://www.buffalowildwings.com/20150628}:RestrictedAssetsCurrent 1 {http://www.altera.com/20150626}:DeferredCompensationPlanRestrictedCashEquivalents 1 {http://www.intgla.com/20141231}:RestrickedCashMortgageImpounds 1 {http://www.voya.com/20150331}:CashAndCashEquivalentsConsolidatedInvestmentEntities 1 {http://aircastle.com/20140630}:RestrictedLiquidityFacilityCollateral 1 {http://www.virtus.com/20140930}:CashPledgedOrOnDepositOfConsolidatedSponsoredInvestmentProducts 1 {http://www.kkr.com/20140630}:CashAndCashEquivalentsHeldAtConsolidatedEntities 1 {http://www.sunedison.com/20150331}:CashCommittedforConstructionProjects 1 {http://www.orm.com/20140630}:CashAndCashEquivalentsAtCarryingValueFundCompany 1 {http://www.altera.com/20150327}:DeferredCompensationPlanRestrictedCashEquivalents 1 {http://www.orchidislandcapital.com/20150630}:MortgageBackedSecuritiesAtFairValueUnpledged 1 {http://www.pnkinc.com/20140630}:CashandCashEquivalentsExcludingDiscontinuedOperations 1 {http://www.carlyle.com/20150331}:CashAndCashEquivalentsAtCarryingValueHeldAtConsolidatedFunds 1 {http://www.tecogen.com/20140630}:CertificateOfDepositsFairValueDisclosure 1 {http://www.carlyle.com/20140630}:CashAndCashEquivalentsAtCarryingValueHeldAtConsolidatedFunds 1 {http://www.ge.com/20150630}:CashAndEquivalentsExcludingAssetsHeldForSale 1 {http://www.dunkinbrands.com/20140927}:RestrictedAssetsOfAdvertisingFunds 1 {http://corp.sohu.com/20150331}:RestrictedTimeDepositsCurrent 1 {http://www.linkp.com/20150331}:CashAndCashEquivalentsExcludingCertificatesOfDeposit 1 {http://www.newresi.com/20140930}:ConsumerLoanEquityMethodInvestments 1 {http://igt.com/20140630}:RestrictedCashAndInvestmentSecuritiesOfVIEs 1 {http://www.buffalowildwings.com/20141228}:RestrictedAssetsCurrent 1 {http://www.dunkinbrands.com/20141227}:RestrictedAssetsOfAdvertisingFunds 1 {http://www.vaalco.com/20140930}:FundsInEscrowCurrent 1 {http://www.altera.com/20140926}:DeferredCompensationPlanRestrictedCashEquivalents 1 {http://www.wendys.com/20140928}:AdvertisingFundsRestrictedAssets 1 {http://carlyle.com/20141231}:RestrictedCashAndCashEquivalentsAndSecuritiesOfConsolidatedFunds 1 {http://www.copt.com/20141231}:RestrictedCashAndMarketableSecurities 1 {http://www.kkr.com/20141231}:CashAndCashEquivalentsHeldAtConsolidatedEntities 1 {http://www.tecogen.com/20150331}:CertificateOfDepositsFairValueDisclosure 1 {http://www.firstmarblehead.com/20141231}:DepositsForParticipationInterestAccounts 1 {http://www.nelnet.com/20140930}:CashAndCashEquivalentsNotHeldAtRelatedParty 1 {http://www.linkp.com/20140630}:CashAndCashEquivalentsExcludingCertificatesOfDeposit 1 {http://www.burlingtoncg.com/20140630}:AvailableForSaleSecuritiesFairValueDisclosureMortgageBackedSecurities 1 {http://www.lazard.com/20140930}:DepositsWithBanksAndShortTermInvestments 1 {http://www.anworth.com/20141231}:MortgageBackedSecuritiesIssuedByPrivateEntities 1 {http://www.apolloresidentialmortgage.com/20140930}:AvailableforsaleResidentialMortgageBackedSecurities 1 {http://www.orm.com/20140630}:CashAndCashEquivalentsAtCarryingValueParent 1 {http://www.intgla.com/20140930}:RestrictedCashRedemption 1 {http://igt.com/20141231}:RestrictedCashAndInvestmentSecuritiesOfVIEs 1 {http://www.ultrapetroleum.com/20140930}:RestrictedCash 1 {http://www.virtus.com/20141231}:CashAndCashEquivalentsOfConsolidatedSponsoredInvestmentProducts 1 {http://www.apolloresidentialmortgage.com/20140630}:AvailableforsaleResidentialMortgageBackedSecurities 1 {http://www.orm.com/20150331}:CashAndCashEquivalentsAtCarryingValueParent 1 {http://www.calpine.com/20140930}:MarginDepositsAndOtherPrepaidExpenses 1 {http://www.orchidislandcapital.com/20141231}:MortgageBackedSecuritiesAtFairValueUnpledged 1 {http://corp.sohu.com/20140630}:RestrictedTimeDepositsCurrent 1 {http://www.aircastle.com/20141231}:RestrictedLiquidityFacilityCollateral 1 {http://www.kennedywilson.com/20141231}:CashHeldbyConsolidatedInvestments 1 {http://www.buffalowildwings.com/20150329}:RestrictedAssetsCurrent 1 {http://www.eatonvance.com/20141031}:CashAndCashEquivalentsConsolidatedVariableInterestEntity 1 {http://www.virtus.com/20140930}:CashAndCashEquivalentsOfConsolidatedSponsoredInvestmentProducts 1 {http://www.pnkinc.com/20140930}:CashandCashEquivalentsExcludingDiscontinuedOperations 1 {http://www.tecogen.com/20140930}:CertificateOfDepositsFairValueDisclosure 1 {http://carlyle.com/20141231}:CashAndCashEquivalentsAtCarryingValueHeldAtConsolidatedFunds 1 {http://www.newresi.com/20150331}:ExcessMortgageServicingRightsEquityMethodInvesteesFairValue 1 {http://www.qtww.com/20140930}:CashAndCashEquivalentsOfContinuingOperationsAtCarryingValue 1 {http://www.newresi.com/20150331}:ExcessMortgageServicingRightsFairValue 1 {http://www.sunedison.com/20140630}:CashCommittedforConstructionProjects 1 {http://americanrealtycap.com/20140930}:PreferredEquityInvestment 1 {http://www.linkp.com/20140930}:CashAndCashEquivalentsExcludingCertificatesOfDeposit 1 {http://www.nelnet.com/20140930}:CashAndCashEquivalentsRelatedParty 1 {http://www.orchidislandcapital.com/20141231}:MortgageBackedSecuritiesAtFairValuePledgedAsCollateral 1 {http://www.voya.com/20140630}:CashAndCashEquivalentsConsolidatedInvestmentEntities 1 {http://www.orm.com/20141231}:CashAndCashEquivalentsAtCarryingValueFundCompany 1 {http://www.eatonvance.com/20150430}:CashAndCashEquivalentsConsolidatedVariableInterestEntity 1 {http://www.lazard.com/20150630}:DepositsWithBanksAndShortTermInvestments 1 {http://www.altera.com/20141231}:DeferredCompensationPlanRestrictedCashEquivalents 1 {http://www.invesco.com/20150331}:CashAndCashEquivalentsOfConsolidatedInvestmentProducts 1 {http://www.wendys.com/20150329}:AdvertisingFundsRestrictedAssets 1 {http://www.qtww.com/20140630}:CashAndCashEquivalentsOfContinuingOperationsAtCarryingValue 1 {http://www.kennedywilson.com/20140630}:CashandCashEquivalentsExcludingCashHeldbyConsolidatedInvestments 1 {http://www.aircastle.com/20140930}:RestrictedLiquidityFacilityCollateral 1 {http://www.buffalowildwings.com/20140928}:RestrictedAssetsCurrent 1 {http://www.firstmarblehead.com/20150331}:DepositsForParticipationInterestAccounts 1 {http://www.eatonvance.com/20140731}:CashAndCashEquivalentsConsolidatedVariableInterestEntity 1 {http://www.nelnet.com/20150331}:CashAndCashEquivalentsRelatedParty 1 {http://corp.sohu.com/20140930}:RestrictedTimeDepositsCurrent 1 {http://orbcomm.com/20141231}:CashHeldForAcquisitionCurrent 1 {http://www.virtus.com/20150331}:CashAndCashEquivalentsOfConsolidatedSponsoredInvestmentProducts 1 {http://www.invesco.com/20141231}:CashAndCashEquivalentsOfConsolidatedInvestmentProducts 1 {http://www.americanrealtycap.com/20140630}:PreferredEquityInvestment 1 {http://www.invesco.com/20140930}:CashAndCashEquivalentsOfConsolidatedInvestmentProducts 1 {http://www.dstsystems.com/20141231}:RestrictedCashAndCashEquivalentsAtCarryingValueOnBehalfOfClients 1 {http://www.cnoinc.com/20141231}:CashAndCashEquivalentsHeldByVariableInterestEntities 1 {http://www.pnkinc.com/20150331}:CashandCashEquivalentsExcludingDiscontinuedOperations 1 {http://www.firstmarblehead.com/20140630}:ParticipationInterestAccount 1 {http://www.orchidislandcapital.com/20150331}:MortgageBackedSecuritiesAtFairValuePledgedAsCollateral 1 {http://www.aecom.com/20140630}:CashAndCashEquivalentsGeneral 1 {http://www.newresi.com/20140630}:ConsumerLoanEquityMethodInvestments 1</pre><h3>Conclusion</h3><p>As we have demonstrated, deriving reliable high-level financial data for investors from XBRL company filings available in the SEC’s EDGAR database is generally more difficult than necessary and unfortunately not 100% reliable.</p><p>However, we were quite surprised in our tests to find that the financial reporting data available from websites such as Google Finance, Yahoo Finance, and Fidelity Investments is also not 100% reliable, and we found numerous cases where the data reported by these sites does not correlate well with one another nor with the actual company filings themselves, which appears to be largely due to the five issues we’ve discussed above.</p><p>We are certainly not alone in reaching these conclusions about the current state of the art of XBRL data quality in the SEC’s EDGAR database. As <a href="https://twitter.com/CharlesHoffman">@CharlesHoffman</a> has written about in numerous blog posts filed under “<a href="http://xbrl.squarespace.com/journal/category/creating-investor-friendly-sec-xbrl-fili">CREATING INVESTOR FRIENDLY SEC XBRL FILINGS</a>” on his <a href="http://xbrl.squarespace.com/">Digital Financial Reporting</a> site, there is a lot of work to be done to improve the data quality and accuracy of XBRL company filings submitted to the SEC.</p><p>Several immediate approaches come to mind that could greatly enhance XBRL data quality:</p><ul><li>Utilizing <strong>XBRL Formula</strong> to implement many of the EDGAR filer manual checks and many more consistency checks and business-level validations directly using the XBRL standard rather than in an external format that cannot be fully automated</li><li>Utilizing <strong>XBRL Table Linkbase</strong> to produce a better and more clearly documented mappings from XBRL facts to high-level financial concepts that are needed by investors</li><li>Requiring that companies produce the <strong>XBRL instance filings as a first-class financial document</strong> — directly from their accounting systems — rather than tagging HTML or PDF files after the fact</li><li>Requiring filers to <strong>run their XBRL instance documents through a rigorous and automated validation and quality check process</strong>, such as the <a href="http://csuite.xbrl.us/">XBRL.US Consistency Suite</a>, or using <a href="http://www.altova.com/">Altova’s</a> <a href="http://www.altova.com/raptorxml.html">RaptorXML+XBRL Server</a>, which provides not only full XBRL standard validation, but also complete <a href="http://blog.altova.com/xml-validation-speeds-reach-new-levels-with-release-4/">EDGAR filer manual validation</a> and can be used either inside <a href="http://www.altova.com/xmlspy.html">XMLSpy</a> interactively for <a href="http://www.altova.com/xmlspy/xbrl-validator.html">XBRL validation</a>, or in an automated server environment for the high-speed validation of large amounts of XBRL data</li><li>Finally <strong>implementing a rigorous quality check in the EDGAR systems at the SEC itself</strong> that only accepts XBRL filings in the first place if they are not only error-free and fully compliant with the specs, but also pass the above-mentioned data quality checks</li></ul><p>Only through a combination of several of these approaches can we succeed in improving XBRL data quality and making the XBRL company filings truly useful for investors.</p><h3>Corollary</h3><p>Seeing how the fundamental investor who wants to find reliable corporate data today apparently has no choice but to go through the difficult exercise of researching a company on multiple sites and potentially going to the original source filings in HTML or PDF format, too, we plan to soon make publicly available a mobile solution — built with <a href="http://www.altova.com/mobiletogether.html">MobileTogether</a> as a front-end and <a href="http://www.altova.com/raptorxml.html">RaptorXML+XBRL Server</a> as well as a SQL database as a back-end — that allows a potential investor to quickly look at high-level data from the last quarterly and annual filings of these public companies, which will be extracted straight from the XBRL filings and summarized for better comparability using heuristics matching.</p><p>Given the restrictions in the data quality discussed above, this data will <em>not</em> be perfect either, but we believe it will be a better match to the intent of the XBRL filings approach and that the data will only improve over time, as XBRL data quality continues to improve.</p><p><em>Originally published at </em><a href="http://blog.altova.com/xbrl-data-quality-of-sec-filings/"><em>blog.altova.com</em></a><em> on September 1, 2015.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a13839b69811" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>