Adding StockScouter rating to Strategy

hmg2020

#1

9/3/2009 6:33 PM

Has anyone tried to incorporate a similar program as that used by stockscout found in this link?
http://www.codeproject.com/KB/aspnet/stockscout.aspx

It would be great to add similar C# code in wealthlab that can do the same as stockscout but for each individual symbol.

If you have an idea how to accomplish something similar please share.

Thanks

Cone

#2

9/4/2009 4:25 AM

If the link for the source weren't broken, you could pretty much copy and paste it in to a WL5 Strategy. Though it would make sense to make some minor changes like using the DataSetSymbols instead of getting them from a file, and outputting the results to the debug window instead of the console.

Eugene

#3

9/4/2009 5:06 AM

The code looks like an overkill for a simple task like this. Let's include it in Community.Components:

CODE:
Please log in to see this code.

http://www2.wealth-lab.com/WL5WIKI/CommunityComponentsMain.ashx

ss161

#4

9/4/2009 7:08 AM

what would also be interesting is to find a source of historical StockScouter ratings to backtest whether or not the rating has any predictive ability.

Eugene

#5

9/4/2009 7:19 AM

Thought of this too, but I'm afraid there isn't such a source. As a workaround, those who are interested in this yet-another-super-duper ratio can start collecting the values and dumping them to a file/database ;)

Cone

#6

9/4/2009 8:18 AM

I knew Eugene could solve this one in a few seconds :)

And, with just a little more work, we can do it for all the DataSetSymbols and display the sorted results -

CODE:
Please log in to see this code.

hmg2020

#7

9/10/2009 11:19 AM

You guys are really good.
In the last scrip is there a way to add to another dataset those symbols that got a 10, say DATSET10 and those that got a 9 be added to DATAset9?

Cone

#8

9/10/2009 11:27 AM

(Hint: don't refresh after posting.)

You can create a combined DataSet with Dave Aronow's WatchList provider.

Eugene

#9

9/10/2009 11:32 AM

There's almost always a way, but this one can work only as Robert said above. You're asking to modify/create a DataSet from Strategy code, and this isn't directly possible. Even when using undocumented API calls - I tried.

(A Strategy can probably modify or create the XML file directly, as a text/XML file, but there's no known way to refresh/make it visible for WL5 other than to restart the application.)

Robert, could you tell us please if the WatchList* methods are planned for 5.6?

hmg2020

#10

9/10/2009 11:44 AM

Sorry for the refresh.
I was looking for an IF then statement in C#...
Are you saying it is not possible with C# to move symbols around within datasets?

Cone

#11

9/10/2009 11:50 AM

No WatchList* in 5.6.

CODE:
Please log in to see this code.

Anything's possible. But now I have little idea what you want to do or even why.

hmg2020

#12

9/10/2009 12:23 PM

I have created a DATAset that includes symbols rated 10 as I run the script above.
The rating changes daily so I wanted to keep the DATAset updated with those new symbols rated 10.

hmg2020

#13

9/10/2009 12:49 PM

If the above script is modified to include only the symbols of those with 10 rating then i can just cut and paste. This will work for me and make it easier to keep the dataset updated.

Eugene

#14

9/10/2009 1:12 PM

CODE:
Please log in to see this code.

hmg2020

#15

9/10/2009 1:32 PM

Thanks, I got it, that will work...
That goes before

CODE:
Please log in to see this code.

hmg2020

#16

12/19/2011 4:09 PM

This code has been giving me errors lately!!!... Error scouting: SCI ...how can it be fixed?

Eugene

#17

12/20/2011 2:43 AM

Microsoft has changed HTML page layout so the GetStockScouter routine from Community Components is broken. Fortunately the workaround is going to be simple.

Look for the fix in the next release of Community Components, 2012.01. You will have to install the extension if you haven't done it before, it's possible to do so now and update early next year when the Extension Manager prompts you to.

Eugene

#18

1/2/2012 7:57 AM

Hector,

Heads-up! GetStockScouter method has been fixed (and improved) so any code relying on it will work after upgrading Community Components to 2012.01.

Eugene

#19

12/19/2015 5:36 AM

ATTENTION! StockScouter has been discontinued by MSN since late 2014. It will no longer work. We are probably going to leave the function in C.Components for now so that any dependent strategy code won't crash. However, GetStockScouter will return -1 for any symbol.