NEWS Feb 18 2010

Stock metadata reports are created from Monday to Friday. They present a combination of historical and statistical data on a stock’s price and number of shares traded. These reports are useful for getting a handle on a stock’s trading activity.

Visitors to our site liked the PDF reports that we delivered but had difficulties importing the PDF data into spreadsheets. When contacting us, they asked us to also make this data available to them, in spreadsheet format if possible.

We listened to them and after much work, the creation of stock metadata reports became a Microsoft Excel application duplicating the functionality of the original system.

But then we were presented us with new challenges. Our hosting provider didn’t allow XLS files to be stored on their servers. Furthermore, the sizes of these files exceeded the e-mail transmission limits which restricted our distribution to snail mail. So we had to find a way to get these reports out to the people who needed them.

After much thought, we came out with a solution to this problem. Most of the interactive functionality was removed from the Excel application. This resulted in smaller files that we could send out using our e-mail facilities.