Clicking a search prediction

[AL1 (Armin Haas)]

Hello!

I am a total beginner and am currently programming a bot to fetch data from the Frankfurt stock exchange. (link in case someone needs it: https://www.boerse-frankfurt.de/ )

So far, I have managed to make the bot type the stock names into the search bar, but now I want the bot to select one of the search predictions.

Ideally, I’d want the bot to look for the closest match, because as you can see, the search predictions of the stock exchange look for the most valueable stock and not the closest match.

Alternatively, it would be enough if you guys can tell me how to click the first prediction and I will just find stocks that are easier to search.

Here’s my bot if you want to check how I worked so far:

Thanks in advance!

[Sudharsan_Ka]

HI @AL1

The list will appear below when you type the text right?

So you can try this

• Use Find Text position and indicate the below list create a variable
• Pass the Variable in the Element property of Click activity.

Regards
Sudharsan

[Angel_Llull (Angel95)]

Hello @AL1,

I have seen that when you type the compnay and click on them, the url change to:

https://www.boerse-frankfurt.de/ + “Company Name”

Maybe if you have a list of companies you can read range. After that:

For each row in datatable:

Assign Activity: Var_CompanyName = row(“Column Name”).Tostring

Open Browser Activity: “https://www.boerse-frankfurt.de/equity” + Var_CompanyName

Warn: I have seen that opening company Daimler AG in url converts to daimler-ag

I hope it helps!

[AL1 (Armin Haas)]

Hi @Angel_Llull !

I actually had the same idea to use variables instead of a search since making my post, but I didn’t know how to do it, so thanks for telling me how!

Just a quick question: Do I need to define the variable somewhere, or does it work to put row(“Column”).Tostring in a Go-To-URL-activity?

Thanks for the reply!

[Angel_Llull (Angel95)]

Inside the for each row activity, you need to use assign activity:

Var_CompanyName = row(“Column Name”).Tostring

Then, also inside the for each row activity, use open browser and write the url:

“https://www.boerse-frankfurt.de/equity” + Var_CompanyName