Find a symbol across DataSets

Author: Sammy_G

Creation Date: 6/4/2010 3:58 PM

Wealth Lab » WealthScript (.NET) » Find a symbol across DataSets

Sammy_G

6/4/2010 3:58 PM

The Data Manager in WLPro v5.6, as in v4.5, lacks the Find function which one would use to locate all occurrences of a symbol in all datasets. Is there a plan to introduce it in a future release? Or is there perhaps a script based solution someone may have developed?

Cone

6/4/2010 4:05 PM

In general, there's no plan to add anything that you can do yourself in a script ;)

CODE:
Please log in to see this code.

Sammy_G

6/4/2010 4:13 PM

Thanks for the fast reply, Cone; it works great! But you have to click on a symbol first. Would you happen to have a version that would pop up with a window or something that prompt you to input the symbol(s)?

Eugene

6/4/2010 4:23 PM

You could use the Input method from Community.Components to pop up a window.

Sammy_G

6/4/2010 4:28 PM

Can you point me to a script that uses it so I can understand its usage?

Eugene

6/4/2010 4:36 PM

Sure, it's the method's description page in the Wealth-Lab Wiki.

Sammy_G

6/4/2010 4:41 PM

OK, will check it out.

Sammy_G

6/4/2010 5:20 PM

Came up with this:

CODE:
Please log in to see this code.

But the results are unreliable, and if the input box is left blank WLPro crashes. Can you fix this?

Cone

6/4/2010 6:14 PM

CODE:
Please log in to see this code.

Sammy_G

#10

6/4/2010 7:14 PM

Still doesn't work right. There's something deeper wrong within the code.

Eugene

#11

6/5/2010 2:58 AM

Neither it crashes for me on any version with blank symbol nor demonstrates unreliable results.

To eliminate any guesswork, what are the symbols with their DataSet names you're having problem with?

Sammy_G

#12

6/5/2010 8:35 AM

Here's the code I'm checking:

CODE:
Please log in to see this code.

I don't know if I changed something, but now it doesn't even popup with an input box either when I click on a symbol or hit the F5 key. Also, when I hit Compile, I get this message in the lower window:
error CS0428 @ (20, 15) : Cannot convert method group 'ToUpper' to non-delegate type 'string'. Did you intend to invoke the method?

Eugene

#13

6/5/2010 8:38 AM

QUOTE:
Also, when I hit Compile, I get this message in the lower window:

Synthax error, check Cone's syntax carefully.

Sammy_G

#14

6/5/2010 10:50 AM

Oh, what a bummer! Got it, fixed it, thanks.

Just one more thing: If I want the input box to remain open for inputting a 2nd or 3rd or 4th etc symbol what should I do? In other words, the box should remain open until I close it w/o typing anything.

Eugene

#15

6/5/2010 11:29 AM

CODE:
Please log in to see this code.

Eugene

#16

6/5/2010 11:32 AM

P.S. Just enter your symbols all at once, separating them with space, comma or ";"

Sammy_G

#17

6/5/2010 2:08 PM

Thanks, Eugene, works great! Only thing is I like to look at symbols' locations one below the other - meaning, all locations for 1 symbol listed first, then locations for symbol 2 listed next, and so on. If you get some time, please try to modify the code to do that.

Eugene

#18

6/5/2010 2:38 PM

Sorry, no - as you understand, I have no time for endless code modifications as it will almost certainly make me sacrifice the other work.

Cone and yours truly have provided you with an example, please feel free to modify it and discover C# along the way.