I have a table |sCode|stockingDate|purchasePrice|qtyRemaining|cost|offeringPrice|P/L| |:----|:----------:|:-----------:|:----------:|:--:|:-----------:|:-:| |G123 |2021-03-06 |2.57 |35 | *1 | *2 | *3|
So when the Browser presents the page I want client-side code to populate *1, *2 & *3 for me for EACH row
*1 should be the qtyRemaining * cost
*2 should be the qtyRemaining * (the value returned by making an API call using sCode)
*3 should then be the offeringPrice / cost
This should allow me to fulfill orders in the most profitable / least Loss way with reference to stock-aging
All help greatly approeciated