in the Google table implemented search for the rosetke i parsing minimal price from issuing (a few hundred goods).
- From the starting table are drawn items, brand and price.
The rubber is removed from the rubber.
- on the roulette is the search for goods brand + articles.
The minimum price of the goods is collected from the issue, in the name of which is accurately present the requested brand + item.
- a reference to the goods, the presence and the name for verification is also encouraged.
- also pars the currency of the dollar from the monobank app, to calculate the prices from the output table.
- a conditional formatting of the deadlines with the conditions of comparison of the starting price and the price on the roulette.
Data update occurs several times a day, or when the file is opened.
Google tables have restrictions on the use of parsing, so in this way you can realize parsing only a small volume.
#Parsing #rozetka #Spreadsheet
- From the starting table are drawn items, brand and price.
The rubber is removed from the rubber.
- on the roulette is the search for goods brand + articles.
The minimum price of the goods is collected from the issue, in the name of which is accurately present the requested brand + item.
- a reference to the goods, the presence and the name for verification is also encouraged.
- also pars the currency of the dollar from the monobank app, to calculate the prices from the output table.
- a conditional formatting of the deadlines with the conditions of comparison of the starting price and the price on the roulette.
Data update occurs several times a day, or when the file is opened.
Google tables have restrictions on the use of parsing, so in this way you can realize parsing only a small volume.
#Parsing #rozetka #Spreadsheet