Help me create position breakdown on excel

Hello everyone. I want to create position breakdown on excel of my concentrated LP on uniswap v3, but i am having problems with the understanding some mechanics and math behind the curves.
I thought that there's a linear proportion of assets over the price range where I am offering liquidity as it is showed in image 1 (my calculation made on excel), but its not the case as it is showed on image 2. I mean, in the point where 2 curves meet, there's no 50/50% ratio, and the curve isn't linear but has convexity. Why is that? Can somebody explain what I should take in consideration to be able to get results expressed in image 2?
My goal its to insert the actual price and price range in specific cells and then the excell formulas and some vba programing will create curves of both assets over the price range, but I don't know how to calculate the asset distribution over the range…
Ps: the ranges expressed on images are just for illustrative end

1 thought on “Help me create position breakdown on excel”

  1. Uniswap Reddit Auto mod post

    1. Never share your Secret Recovery Phrase with any site or person. Do not enter your Secret Recover Phrase into a pop-up window.
      Verify links are legitimate. Scammers often use these tactics.

    2. Beware of fake websites. The official website for Uniswap is https://uniswap.org/

    3. Beware of fake Twitter/X accounts. The official Twitter is https://twitter.com/Uniswap

    4. Our official Discord is https://discord.gg/D2zmtd3cUZ

    5. Uniswap Support will never DM you. We only handle support through support@uniswap.org and https://support.uniswap.org/hc/en-us/requests/new.
      Scammers use DMs to try and get access to your wallet.

    6. Do not click on suspicious links or files. This can lead to your device security being compromised.

    7. Do not “sync” or “validate” your wallet with any websites or forms. This is a scam. Never sync and share: QR Codes, Secret Recovery phrases, private keys, etc.

    8. Uniswap Labs has no plans for an airdrop, regardless of any information you may have seen elsewhere.

    I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

Comments are closed.