PDA

View Full Version : Program to populate multiple fields in multiple programs with the same text???


JeffreyJim
05-21-2011, 07:56 AM
Sorry for the vague title.

Here is what I'm looking for: I work in finance and as part of my job often find myself putting the same ticker into 8 different fields to search for information/news/etc. Sounds like no big deal but when you have to go through 60 of these in 40 minutes searching for news it is a pain in the ass toggling between screens, windows etc to enter the EXACT SAME INFORMATION into a STATIC NUMBER OF FIELDS.

My programming ability isn't good enough to write something that does this for me (although I might try anyway).

Is there anything out there that allows you to put text into a field and when you hit "search" or whatever it actually inputs the text into all the fields you have specified and runs a defined action?

Thoughts? Bueller? Anyone?

My goal is I put the ticker into the ONE window, hit enter and it searches my various sources (google, google realtime, Reuters Trader, FactSet, StreetAccount etc)
schuss
05-21-2011, 01:23 PM
You could do this either via macro/automated test software (which would be somewhat error prone, as it's looking for things in specific areas/with a specific structure on the page), but a better route would be something that hooks into all the API's and returns the results based on that.
milton
05-23-2011, 08:11 AM
AutoIT

http://www.autoitscript.com/site/autoit/
RShea
05-23-2011, 08:09 PM
There are "macro" recording programs out there that probably could handle part of this. You of course probably are using different text each time- so no way to automate the full script with a macro/keystroke recorder. But copy one of the fields, then paste it to all the other sites.
stuckathuntermtn
05-23-2011, 08:37 PM
ctrl + c
ctrl + v
JeffreyJim
05-24-2011, 06:40 AM
ctrl + c
ctrl + v

Ha. Yeah, I do that now. I would be materially faster if I had a program do it for me in real time which would help get the report I'm doing out faster (time sensitive).
Cyber Cop
05-24-2011, 06:52 AM
ctrl + c
ctrl + v

lol, that was my answer too...
Cyber Cop
05-24-2011, 07:00 AM
but a better route would be something that hooks into all the API's and returns the results based on that.

Do all of the services you need have a public api? I checked reuters and they do. You would think there is already software built to do this. If not, maybe it's worth your time to make it and then sell the software too.
under the radar
05-25-2011, 09:41 PM
Check out AutoIt. Even if you have never programmed, there is a recorder that you would pick it up fast. I use it a lot for this sort of thing