Forum Academy Marketplace Showcase Pricing Features

How to update Crypto wallet with price change

Please I need help on how to properly update prices.I am using coingecko API.Example
Say a user buys $25 worth of bitcoin.This shows on the dashborad as $25.

  1. what market data time such as 1h,24h etc is best to use to ensure I(Admin)does not pay more or less of actual market value when user is withdrawing.
    2)How do i update the prices.Example,the $25 drops by 1% so price becomes $24.75. THEN price Increase by 2%.How to do these changes in database?