{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/99ececd510ff486fb616b3d61f31f5dc\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/99ececd510ff486fb616b3d61f31f5dc-1688123176914.gif","duration":321.83000000000027,"title":"Sample Price Ladder","description":"Hi Mr. Excel community, thank you for your assistance. In this video, I explain how to create a price ladder in Google Sheets and how it works. I show how the contract price times the quantity gives us a position size, and how the price ladder is created based on this entry price. I also explain how the plan to stop loss works and how to find the appropriate level for that particular stop-loss. The requested solution is to create a formula or function that can automatically create this price ladder based on the user-entered information. The video also shows how the price ladder gets created up to 100% to the positive and down to 100% to the negative, and how the entry price gets highlighted using conditional formatting."}