Quote:
Originally Posted by CaramonLS
Save some steps and build an HFT machine. Free money.
|
Lol, well its not that "advanced".
Quote:
Originally Posted by photon
If you can do it for one, then it's just a matter of copying the formula many times isn't it?
Can the formula fit in an Excel spreadsheet formula?
If you had a spreadsheet with Column A being Stock names, Column B being prices, and Column D being the result of the formula, is it that straight forward?
|
Well its a lot more complex than that. Say I need a specific metric from a set of financials....let's say that I want to take the net revenue of Apple and then divide it into the gross revenue. Now I want to do that for every stock the NYSE, Nasdaq and TSE. (I know that this screen is available...that's not what I'm trying to do here, its an example).
Basically what I want to do is a series of those types of calculations, screen those results. Do more calculations on the remaining results., and then screen those. Then lastly more calculations and rank the remainder.