As an attempt to resolve an apparent problem while conducting real transactions in Bitcoin with lightning. I've derived a simplified list of prices of dollars denominated in round numbers of Sats (bitcoin). This allows a person to reduce constant consultation of the transient market price of Bitcoin.
To use this list, you check the price of bitcoin periodically and find the row where the current price is between "$/BTC Low" and "$/BTC High", and write down the number of Sats per dollar in a predominant place along with the time.
When transacting, for example, if you want to pay $10.00 in sats, multiply the two to yield the amount. If the present price per bitcoin is $54,321.09, the number of sats per dollar from the table is 1860. $10 is 18600 sats. $3.21, calculated is 5970.6, and rounded is 5971.
The prime advantage of this mechanism is the number 1860 is the only number you need to remember and this number will only change a few times per day by a whole number amount. Your dollar-transaction can be multiplied by this memorized number.
The list below is computed from a spreadsheet, that I've posted here based on a maximum +/-2.5% exchange rate error between dollars and bitcoin. This could be useful for small day-to-day transactions and if the rate is updated periodically (assuming the price is random), every few hours, the net gain and loss should eventually average to zero.
| Sat/$ | $/BTC Low | $/BTC High |
|---|---|---|
| 3300 | $30,076.89 | $30,536.13 |
| 3250 | $30,536.13 | $31,009.62 |
| 3200 | $31,009.62 | $31,498.02 |
| 3150 | $31,498.02 | $32,002.05 |
| 3100 | $32,002.05 | $32,522.47 |
| 3050 | $32,522.47 | $33,060.11 |
| 3000 | $33,060.11 | $33,615.82 |
| 2950 | $33,615.82 | $34,190.53 |
| 2900 | $34,190.53 | $34,785.24 |
| 2850 | $34,785.24 | $35,401.00 |
| 2800 | $35,401.00 | $36,038.96 |
| 2750 | $36,038.96 | $36,700.34 |
| 2700 | $36,700.34 | $37,386.44 |
| 2650 | $37,386.44 | $38,098.69 |
| 2600 | $38,098.69 | $38,838.61 |
| 2550 | $38,838.61 | $39,607.84 |
| 2500 | $39,607.84 | $40,408.16 |
| 2450 | $40,408.16 | $41,241.50 |
| 2400 | $41,241.50 | $42,109.93 |
| 2350 | $42,109.93 | $43,015.73 |
| 2300 | $43,015.73 | $43,961.35 |
| 2250 | $43,961.35 | $44,949.49 |
| 2200 | $44,949.49 | $45,983.09 |
| 2150 | $45,983.09 | $47,065.34 |
| 2100 | $47,065.34 | $48,081.37 |
| 2060 | $48,081.37 | $49,024.32 |
| 2020 | $49,024.32 | $50,005.00 |
| 1980 | $50,005.00 | $51,025.72 |
| 1940 | $51,025.72 | $52,088.99 |
| 1900 | $52,088.99 | $53,197.51 |
| 1860 | $53,197.51 | $54,354.25 |
| 1820 | $54,354.25 | $55,562.42 |
| 1780 | $55,562.42 | $56,825.52 |
| 1740 | $56,825.52 | $58,147.40 |
| 1700 | $58,147.40 | $59,532.25 |
| 1660 | $59,532.25 | $60,608.29 |
| 1640 | $60,608.29 | $61,352.00 |
| 1620 | $61,352.00 | $62,114.20 |
| 1600 | $62,114.20 | $62,895.57 |
| 1580 | $62,895.57 | $63,696.85 |
| 1560 | $63,696.85 | $64,518.81 |
| 1540 | $64,518.81 | $65,362.27 |
| 1520 | $65,362.27 | $66,228.07 |
| 1500 | $66,228.07 | $67,117.12 |
| 1480 | $67,117.12 | $68,030.36 |
| 1460 | $68,030.36 | $68,968.80 |
| 1440 | $68,968.80 | $69,933.49 |
| 1420 | $69,933.49 | $70,925.55 |
| 1400 | $70,925.55 | $71,946.17 |
| 1380 | $71,946.17 | $72,996.59 |
| 1360 | $72,996.59 | $74,078.14 |
| 1340 | $74,078.14 | $75,192.22 |
| 1320 | $75,192.22 | $76,340.33 |
| 1300 | $76,340.33 | $77,524.04 |
| 1280 | $77,524.04 | $78,745.04 |
| 1260 | $78,745.04 | $80,005.12 |
| 1240 | $80,005.12 | $81,306.19 |
| 1220 | $81,306.19 | $82,650.27 |
| 1200 | $82,650.27 | $84,039.55 |
| 1180 | $84,039.55 | $85,476.33 |
| 1160 | $85,476.33 | $86,963.10 |
| 1140 | $86,963.10 | $88,502.51 |
| 1120 | $88,502.51 | $90,097.40 |
| 1100 | $90,097.40 | $91,750.84 |
| 1080 | $91,750.84 | $93,466.11 |
| 1060 | $93,466.11 | $95,246.73 |
| 1040 | $95,246.73 | $97,096.53 |
| 1020 | $97,096.53 | $99,019.61 |
| 1000 | $99,019.61 | $101,020.41 |
Feel free to print this table out on a paper and use it to update your posted exchange rate.
Comment below to request a refreshed file link.