I want to put price qty and exchange_name but if the price already in the table i just want to update the quantity. if the price is not in the table I want to insert it. Is there a function to check if the price is already present, update it and if not insert it? Else how do I check if price in the table .
table:([]price:();qty:();exchange_name:())
Can't you key the table by price (or price/exchange if that is what you need) and upsert the fields that way? In code:
table:([] price:`float$(); qty:`int$(); exchange_name:`symbol$());
table:xkey[`price;table];
You can insert the rows as follow:
table:table upsert (20;200;`XPAR)
If you try to insert a row whose price is already shown in the table, qty and exchange_name will be updated; otherwise, a new row will be inserted.