Winning online Auctions

COVID-19 pandemic spreads to all corners of the globe, leading to a subsequent economic fallout. While many businesses and groups were impacted. More and more products are sold online, the offers of products in online auctions is increased as is the amount of bidders.

Me as a BBQ MEAT lover am interested in good deals buying good meat. Would it be possible to save a lot of money if Yarado can do the bidding for me ?

What is the minimum price during 24/7 price indexing, and is there a big difference in the night or early morning.


Why not get answers to these questions by building a Yarado task and make it available for download or reference.

Auction.zip (31.6 KB)


Building the Task

  1. I do not want to win 10 auctions in a row, so a trigger is required to prevent buying lots of meat.
  2. 24/7 Hammering the system and Microsoft Edge, avoid reaching application limits can be difficult.
  3. Sync to the countdown clock
  4. Override Anti Robot
  5. Validate the bidding
  6. The task needs to be able to index the auction 24/7 to determine the best price
  7. Task needs to be reusable for other interesting Auction Products
  8. Orchestrator vs Endless loop
  9. Did I win ?
  10. What Products do You want to win ?


1.Prevent task to win multiple auctions
When %taskpath%\WE_WON.txt exists the task will set highest bid to 0. This will prevent Yarado from winning a lot of auctions in a row but still harvest data. On restart simple remove the trigger file to start bidding again.



2. Prevent memory overload
Web-browsers are eating memory away if allowing to enter inhuman amounts of clicks / pages / forms. To prevent in this case edge from eating away to many system resources The edge browser is started at the beginning of the task and closed at the end.

MsEdge is started from a Hidden Command step. MsEdge.exe + URL should start from command pompt. If that is not the Case use the full path “C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe”


2a. Start MsEdge.exe
image


2b. Close MsEdge.exe



3. Sync to countdown clock
image

The Auction site does not show the countdown timer as 1 label, but as different sections
Set an anchor point onto the €, from there the mouse is moved to section [03] this text is grabbed
after that the mouse is moved further to the right[43] and that text is also grabbed. These are appended together so 03:43 becomes 0343

While the countdown timer is not < %delay% The highest bid is collected to determine if it is still lower then the maximum I want to spend. This is done by moving the mouse form the last countdown section to the highest bid section. Again collecting the data.

The current bid delay is set to 3 seconds. The bidding starts when the timer hits 3 or 2. To place our bid as late as possible. If countdown timer hits the last 3 seconds, the bid is placed.


Subtask Get_Bid is used to determine the correct amount to bid. Base on Max Bid, Raise and highest Bid.



4. Override Anti Robot


This mistake can become costly, I ended up winning the auction for an amount of 5 times larger than the highest amount I wanted to pay :hot_face:. The reason for this was a friendly help from the auction site, where they placed a suggestion as input for me to only press enter as an auto suggest. Not clearing the textbox before entering the amount can become very was costly.

Thanks to good support the order got canceled, I told them my keyboard was stuck :wink:


To make sure that does not happen again, clear the textbox using {CTRL+A} before entering the desired bid.
image


5. Validate the bidding
Once the timer hits 0, the ‘winner’ is revealed. For logging and analytics all winners + timestamp + highest bid is logged. Trend analysis can be done on this data revealing the best time to win the auction for the lowest price.

image

Anchor point is set on “En de winnaar is…” from there moved into position to collect the highest bid, and finally move to collect the winners name

also the %taskpath%\WE_WON.txt is set if WE are the winner preventing meat stacking up.


6. The task needs to be able to index the auction 24/7 to determine the best moment
Saving the data Date/Time;Winner;Amount to .csv file for analysis


Date Highest Bid Name
2021-01-11 15:22 21 Ceoray Rozenboom
2021-01-11 15:36 14 rob klaassens
2021-01-11 16:23 18 Bastiaan Roubos
2021-01-11 16:27 22 Ronald Bronkhorst
2021-01-11 16:32 19 Han van der Vlist
2021-01-11 16:38 18 E.A. Broeks
2021-01-11 17:06 23 C van Unen
2021-01-11 17:35 19 Jacco Konter
2021-01-11 17:50 12 William Stenfert
2021-01-11 19:12 17 Cor Van Beesten
2021-01-11 19:20 15 Gunther Dilles
2021-01-11 20:03 18 Sandra D B
2021-01-11 20:11 13 Thijs van Voorthuizen
2021-01-11 20:19 15 Pc Delfgou
2021-01-11 20:27 19 ron smit
2021-01-11 20:35 11 jeanette osinga
2021-01-11 20:44 16 Anthonie Woldring
2021-01-11 20:53 16 Robby Hofs
2021-01-11 21:01 17 Edward Verspaandonk
2021-01-11 21:10 17 Tim Pootjes
2021-01-11 21:18 10 Wim Jansen
2021-01-11 21:26 14 Renske Oosterbosch
2021-01-11 21:35 10 A A Lekker eten
2021-01-11 22:55 17 Mark Ivangh
2021-01-11 23:14 16 Cinthia Ameerun
2021-01-11 23:26 14 HouHetLaag DomHe
2021-01-11 23:40 11 Jaap Musch
2021-01-11 23:55 15 Nana Ansah
2021-01-12 00:14 22 Michael Schaafstal
2021-01-12 00:39 16 Jessica Sondervan
2021-01-12 01:17 14 M.V. Evers
2021-01-12 07:47 15 Paul Vrins
2021-01-12 08:15 14 Ryan Forrest
2021-01-12 08:40 11 Peter Ouwerkerk
2021-01-12 10:23 14 Sigrid ter Voort
2021-01-12 10:38 10 Rachelle Balfour van Burleigh
2021-01-12 10:52 14 Rinke van Hal
2021-01-12 11:06 16 Anneke Dijk van Krieken
2021-01-12 11:20 16 J.J.C .
2021-01-12 11:34 16 jos srevens
2021-01-12 11:48 14 Wieke Tekstra
2021-01-12 12:01 13 Thobias Slooijer
2021-01-12 12:14 13 M. ten Berge
2021-01-12 12:27 7 v kronenburg
2021-01-12 12:40 13 Willem II
2021-01-12 12:53 12 Quincy Berkelmans
2021-01-12 13:06 19 J. de Weerd
2021-01-12 13:19 11 Roelof Reinders
2021-01-12 13:46 13 mi veeke
2021-01-12 14:00 11 Erica Zapata
2021-01-12 14:14 15 wilhelmina de schrijver
2021-01-12 14:29 13 Joyce Peeters
2021-01-12 14:44 15 Bert Wieling
2021-01-12 14:59 11 Dj Riemersma
2021-01-12 15:14 13 Susana Goncalves
2021-01-12 15:43 11 Dj Riemersma

Over 24 hours the bid amount of 10 seems to be the sweet spot.


7. Task needs to be reusable for other interesting Auction Products
Instead of recording in normal mode, the anchor points are recorded as Template matching, making the task able to run on different resolutions and or different browsers.


8. Orchestrator vs endless loop
The task will be running 24/7, the risk that Edge does not respond or Yarado stops responding is applicable. In the download files there are 2 version. The endless loop version which is less stable and needs business rules to optimize further. The Orchestrator version is set to run for 24/7 by scheduling with an interval of every 5 minutes auto correcting possible issues.


9. And the Winner is :grinning:


10. What product do You want to win :grinning:
Leave a comment on what products you won.

Auction.zip (31.6 KB)

5 Likes

Nice! Props… na drie runs was de veiling voor mij.
Dat word lekker grillen hier Bedankt Barry :stuck_out_tongue_winking_eye:

image

5 Likes