Open Access. Powered by Scholars. Published by Universities.®
- Discipline
- Keyword
Articles 1 - 2 of 2
Full-Text Articles in Business
An Automation Algorithm For Harvesting Capital Market Information From The Web, Pankaj Agrrawal
An Automation Algorithm For Harvesting Capital Market Information From The Web, Pankaj Agrrawal
Finance Faculty Scholarship
The purpose of this paper is to develop an algorithm to harvest user specified information on finance portals and compile it into machine‐readable datasets for quantitative analysis. The Visual Basic macro language in Microsoft Excel is applied to develop code that is not constrained by the single‐query function of Excel. The core of the algorithm is built around the splitting of the URL connector line and the placement of a continuously updating variable into which are looped as many tickers as there are in the input list. The output is then written to non‐overlapping cells. Numerical information placed on major …
The Effects Of Blending Primary And Diluted Eps Data, Ralph Goldsticker, Pankaj Agrrawal
The Effects Of Blending Primary And Diluted Eps Data, Ralph Goldsticker, Pankaj Agrrawal
Finance Faculty Scholarship
The paper predicted in 1999 that the growth rates of technology companies was overstated. Once the executives of these companies would exercise their stock options, the blending of primary and diluted EPS would lower the estimated growth rates. Valuations would subsequently get adjusted (downwards) by the market. This happened over the 2000-2003 bear market. A similar adjustment is now used in the Returnfinder Total Returns app algorithm, which provides dual returns for the ticker entered.