Hi, @danp,
I have an update on this thread and some new questions. First the update: the file “List of factors.xlxs” finally made sense to me. In my Open Office version of the file, the graph in the worksheet “Chart” had 18 columns in it instead of 20. I falsely concluded that those columns represented years and the cumulative performance of the years. But I finally discovered that the first 2 points of data for a given row were not displayed on the bar graph, only data points 3 - 20. Also, in my version of the spreadsheet I had numerous versions of “#NAME?” and “#DIV/0” error messages. When I figured out that many of the “#DIV/0” errors were caused by cells containing references to rows that contained no data and fixed those references, then a whole lot of the data displayed sensible numbers.
So now to my questions: (1) how many API credits does the script take to produce the data for 1 factor? (2) from where does the script get the list of factors to try? You mentioned that “[i]t was not a complete list even back then and doesn’t have all the good factors we have added lately”, so how do I make the list complete? I doubt the list of factors produced by examining the factors as provided by P123 “LEARN AND CONNECT” => “RESEARCH” => “Factor Reference” would include the kinds of factors such as the factor under “Category” called “Momentum” and “Formula” of “sma(120)/sma(240)”. So where would I find those factors?
Thanks for your help.
Cary