Hello, for 3 days im staring at my screen entire day to figure out how to get data from a simple webpage conating simple text..;the text is withing the body and does not conain any id or class to prefer to...
im creating an excel spreadsheet of all the casino's i play...
it contains all my deposits, passwords, withdrawns and specially all the jackpot values each day, from each slot from each stake so i can simply get an overlook where i want to play that day.
now i figuered out how to see fastest way the values of a slot of instead everytime logging in, loading the slot, and change each stake to see the values.
one of the links:
https://be3-gameapi.airdice.com/games/api/MegaWheels/real/bet333_prd/getJackpots
and this is the fysical text paging on the site:
<jackpotsResponse>
<time>1727186155257</time>
<jackpotValues>
<jackpot id="megawheelsjp_2.50" group="bet333" value="3200.09" bet="2.50" totalBet="2.50"/>
<jackpot id="megawheelsjp_0.25" group="bet333" value="208.07" bet="0.25" totalBet="0.25"/>
<jackpot id="megawheelsjp_25.00" group="bet333" value="11892.48" bet="25.00" totalBet="25.00"/>
<jackpot id="megawheelsjp_1.50" group="bet333" value="2017.62" bet="1.50" totalBet="1.50"/>
<jackpot id="megawheelsjp_15.00" group="bet333" value="4769.83" bet="15.00" totalBet="15.00"/>
<jackpot id="megawheelsjp_0.50" group="bet333" value="226.21" bet="0.50" totalBet="0.50"/>
<jackpot id="megawheelsjp_20.00" group="bet333" value="6760.76" bet="20.00" totalBet="20.00"/>
<jackpot id="megawheelsjp_5.00" group="bet333" value="2059.65" bet="5.00" totalBet="5.00"/>
<jackpot id="megawheelsjp_1.00" group="bet333" value="673.29" bet="1.00" totalBet="1.00"/>
<jackpot id="megawheelsjp_2.00" group="bet333" value="1248.64" bet="2.00" totalBet="2.00"/>
<jackpot id="megawheelsjp_10.00" group="bet333" value="3108.24" bet="10.00" totalBet="10.00"/>
</jackpotValues>
</jackpotsResponse>
in the inspector of source you only have this:
<html>
<meta name........
<Meta id="..............."Name="......"
</head>
<body>
<pre style= ...........>
and the the jackpot strings as above shown
</pre>
</body>
</html>
thats it...
Only thing i want is to when i run my macro ( with a button or something else ) he put the values on my sheet so i can go further so it auto place it in the right spot each day..
Can plz someone help me because everything i found seems so complicated and there are solutions for everything but i cant seem to find mine... im working with excel 2003 and i want to use chrome to get the data.
thanks in advance, Stefan