Bitcoin Forum
May 02, 2024, 01:15:48 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1] 2 »  All
  Print  
Author Topic: BTC value at msg date  (Read 307 times)
npuath (OP)
Copper Member
Jr. Member
*
Offline Offline

Activity: 42
Merit: 67


View Profile
January 25, 2023, 04:54:10 PM
Last edit: January 29, 2023, 11:03:02 PM by npuath
Merited by BenCodie (3)
 #1

As a newbie I've been browsing several interesting topics here, some really old. In several posts, amounts in BTC are mentioned (like "My bitcoin digital casino only allows deposits of max BTC50).

It would be nice to be able to quickly lookup the $/BTC at each post's date, perhaps by hovering over the post date.



Update

I made a quick demo, try it out:
https://ztt.se/test:bct_pdq/index.php?topic=92.20

Any subpage works, just replace bitcointalk.org with ztt.se/test:bct_pdq in the URL.

The <title> html tag (to show hover text) in the forum date div is already used (to show Last edit date), and anyway it's not always clear how to hover on touch devices, so I resorted to explicitly append the dollar quote to the date, in green.

Check out topic number five, where Satoshi welcomes users to this forum (1, 2, and 4 exist in the staff forum; 3 was permanently deleted at some point because it contained Satoshi's real name and address):
https://ztt.se/test:bct_pdq/index.php?topic=5



User profiles

The demo appends historical quotes to any date (if it's alone in its div), so it works on user profiles as well:
https://ztt.se/test:bct_pdq/index.php?action=profile;u=897509


1714612548
Hero Member
*
Offline Offline

Posts: 1714612548

View Profile Personal Message (Offline)

Ignore
1714612548
Reply with quote  #2

1714612548
Report to moderator
1714612548
Hero Member
*
Offline Offline

Posts: 1714612548

View Profile Personal Message (Offline)

Ignore
1714612548
Reply with quote  #2

1714612548
Report to moderator
"With e-currency based on cryptographic proof, without the need to trust a third party middleman, money can be secure and transactions effortless." -- Satoshi
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714612548
Hero Member
*
Offline Offline

Posts: 1714612548

View Profile Personal Message (Offline)

Ignore
1714612548
Reply with quote  #2

1714612548
Report to moderator
digaran
Copper Member
Hero Member
*****
Offline Offline

Activity: 1330
Merit: 899

🖤😏


View Profile
January 25, 2023, 06:09:40 PM
 #2

So what you are saying is that when you use BTC in your comment, forum should take a snapshot from the market price and save it? What if I edit my post after 2 years, which price should be shown, the first post or the edited post?
Good luck convincing theymos aka The Boss.

🖤😏
npuath (OP)
Copper Member
Jr. Member
*
Offline Offline

Activity: 42
Merit: 67


View Profile
January 25, 2023, 07:01:24 PM
 #3

... when you use BTC in your comment, forum should take a snapshot from the market price and save it? ...

Much simpler: Regardless of post contents, when hovering over the post timestamp, show that timestamp's btc market value (eg $/BTC). No need to scan post content, no need to save anything. Historical market values are readily available, just look up the date we're hovering over.

... which price should be shown, the first post or the edited post? ...

Good point, didn't think of that. The first I think, since I first missed this functionality when I read old posts; if the edit date is used, a recent edit wouldn't give me the historical context I missed.

... Good luck convincing theymos aka The Boss. ...

Thanks  Cheesy
PX-Z
Hero Member
*****
Offline Offline

Activity: 1442
Merit: 836


Top Crypto Casino


View Profile WWW
January 25, 2023, 09:54:41 PM
 #4

That's interesting, but won't work in the current forum software unless someone make a browser plugin for it. The idea is to show the BTC price when hovered the post with API when a BTC tag is detected to a post based on the post's timestamp.

On the other hand, you can manually check the price by looking CMC with the post's timestamp.

█████████████████████████
████▐██▄█████████████████
████▐██████▄▄▄███████████
████▐████▄█████▄▄████████
████▐█████▀▀▀▀▀███▄██████
████▐███▀████████████████
████▐█████████▄█████▌████
████▐██▌█████▀██████▌████
████▐██████████▀████▌████
█████▀███▄█████▄███▀█████
███████▀█████████▀███████
██████████▀███▀██████████
█████████████████████████
.
BC.GAME
▄▄░░░▄▀▀▄████████
▄▄▄
██████████████
█████░░▄▄▄▄████████
▄▄▄▄▄▄▄▄▄██▄██████▄▄▄▄████
▄███▄█▄▄██████████▄████▄████
███████████████████████████▀███
▀████▄██▄██▄░░░░▄████████████
▀▀▀█████▄▄▄███████████▀██
███████████████████▀██
███████████████████▄██
▄███████████████████▄██
█████████████████████▀██
██████████████████████▄
.
..CASINO....SPORTS....RACING..
█░░░░░░█░░░░░░█
▀███▀░░▀███▀░░▀███▀
▀░▀░░░░▀░▀░░░░▀░▀
░░░░░░░░░░░░
▀██████████
░░░░░███░░░░
░░█░░░███▄█░░░
░░██▌░░███░▀░░██▌
░█░██░░███░░░█░██
░█▀▀▀█▌░███░░█▀▀▀█▌
▄█▄░░░██▄███▄█▄░░▄██▄
▄███▄
░░░░▀██▄▀


▄▄████▄▄
▄███▀▀███▄
██████████
▀███▄░▄██▀
▄▄████▄▄░▀█▀▄██▀▄▄████▄▄
▄███▀▀▀████▄▄██▀▄███▀▀███▄
███████▄▄▀▀████▄▄▀▀███████
▀███▄▄███▀░░░▀▀████▄▄▄███▀
▀▀████▀▀████████▀▀████▀▀
Welsh
Staff
Legendary
*
Offline Offline

Activity: 3262
Merit: 4110


View Profile
January 25, 2023, 11:14:33 PM
 #5

It's a funky idea, but I'm not sure this would be useful for the vast majority of users, and would just be extra clutter. The minority that would benefit from something like this could probably search this up themselves.

That's interesting, but won't work in the current forum software unless someone make a browser plugin for it. The idea is to show the BTC price when hovered the post with API when a BTC tag is detected to a post based on the post's timestamp.

On the other hand, you can manually check the price by looking CMC with the post's timestamp.
I don't think it would be too much work to implement, but I'm not convinced by the usefulness of it. It's fairly easy to search this information up yourself, and while it might seem lightweight, we've already had to disable certain features of the forum to avoid downtime, so adding features like this which has to query from another source, can both be exploited due to relying on that third party, but also does add some overhead to the resources.
jackg
Copper Member
Legendary
*
Offline Offline

Activity: 2856
Merit: 3071


https://bit.ly/387FXHi lightning theory


View Profile
January 26, 2023, 12:00:29 AM
 #6

It's a funky idea, but I'm not sure this would be useful for the vast majority of users, and would just be extra clutter. The minority that would benefit from something like this could probably search this up themselves.

I was thinking this myself. I don't think the forum would be able to handle something like that either - it has to do recounts every few weeks and those change numbers for older members quite a lot - I reckon there'll be a lot of errors with a system like that that just makes it too hard to edit (ie bitcoin is $0 on 1st January 2022 because the api broke).

APIs that do fiat conversions in wallets also get broken quite a bit too so I think that'd happen here - it's also a lot easier to get multiple reliable sources to find the value of bitcoin from a search engine (and they'll have native currencies too).
avp2306
Sr. Member
****
Offline Offline

Activity: 994
Merit: 348



View Profile
January 26, 2023, 01:08:49 AM
 #7

As a newbie I've been browsing several interesting topics here, some really old. In several posts, amounts in BTC are mentioned (like "My bitcoin digital casino only allows deposits of max BTC50).

It would be nice to be able to quickly lookup the $/BTC at each post's date, perhaps by hovering over the post date.

Not their obligation to keep you updated on the price of bitcoin so better grab coinmarketcap and see the bitcoin price time to time.

Their duty is to maintain the forum and not to spoil lazy brats.

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
MΞTAWIN  THE FIRST WEB3 CASINO██████
██
██
██
██
██
██
██

██

██

██

██

██████
.
 PLAY NOW 
██████
██
██
██
██
██
██
██

██

██

██

██

██████
Welsh
Staff
Legendary
*
Offline Offline

Activity: 3262
Merit: 4110


View Profile
January 26, 2023, 10:25:11 PM
 #8

I was thinking this myself. I don't think the forum would be able to handle something like that either - it has to do recounts every few weeks and those change numbers for older members quite a lot - I reckon there'll be a lot of errors with a system like that that just makes it too hard to edit (ie bitcoin is $0 on 1st January 2022 because the api broke).

APIs that do fiat conversions in wallets also get broken quite a bit too so I think that'd happen here - it's also a lot easier to get multiple reliable sources to find the value of bitcoin from a search engine (and they'll have native currencies too).
Basically, constantly fetching the values, and presenting that. It could even potentially slow down the responsiveness of the page if it's rather resource heavy. Depends on how it would be implemented. I haven't played around with too many APIs when it comes to fetch the values of Bitcoin. I suspect if there's as many problems as you suggest, it's likely coming from the source as well as how it's been implemented in the wallets. It just seems like a idea which would be useful for a very select few, and likely wouldn't offer too much to the vast majority of the forum. I can see maybe some usefulness to it, but personally I'd probably never use it.
npuath (OP)
Copper Member
Jr. Member
*
Offline Offline

Activity: 42
Merit: 67


View Profile
January 28, 2023, 08:40:21 AM
Last edit: January 28, 2023, 09:03:24 AM by npuath
 #9

It just seems like a idea which would be useful for a very select few, and likely wouldn't offer too much to the vast majority of the forum.

Got you, though my guess is that many users on this forum actually are quite select  Grin
This post from theymos is what first prompted me to check a historical BTC quote. I'm sure many of you legends know the value of 6000+ BTC in 2013, but remember I'm a newbie.

I actually vaguely remember something about the infamous pizzas, from when it happened I mean, but I'll be darned if I can remember exactly which year it was, or how many coins were paid.

(I looked it up; I'm sure most of you already know this, but it was May 2010 when Laszlo Hanets bought two Jacksonville pizzas for 10,000 BTC. Two months earlier, user "SmokeTooMuch" auctioned 10,000 BTC for $50 but no buyer was found.)

I was thinking this myself. I don't think the forum would be able to handle something like that either - it has to do recounts every few weeks and those change numbers for older members quite a lot - I reckon there'll be a lot of errors with a system like that that just makes it too hard to edit (ie bitcoin is $0 on 1st January 2022 because the api broke).

APIs that do fiat conversions in wallets also get broken quite a bit too so I think that'd happen here - it's also a lot easier to get multiple reliable sources to find the value of bitcoin from a search engine (and they'll have native currencies too).
Basically, constantly fetching the values, and presenting that. It could even potentially slow down the responsiveness of the page if it's rather resource heavy. Depends on how it would be implemented.

You're right of course, it depends on how it'd be implemented.

However, assuming a local cache of the historical quotes (some 4500 day entries since 2010-07-17, a couple of KiB; this could be updated once a day or so), even a naive serverside implementation would be very lightweight; a simple SELECT extension in the post loop and a tiny attribute addition to the date HTML (eg title='$23,133').

In fact, I could even do it externally by proxy with little effort, even though this would incur several magnitudes of more overhead: for starters, my external proxy server would have to fetch the page from a real bitcointalk server, so I'll always be slower, even without modifications. Since I'm a single end-point, I'm most likely also rate-limited on the transport level. And of course I'd have to decrypt and re-encrypt since it's SSL. Also, instead of a puny addition to an existing post loop using a hopefully optimised DB engine, I'd have to parse and modify end-formated http data (150 KiB for this small topic before I post this).

It's absolutely possible though, with only a modest time delay IMHO (hover over any post date to see that date's BTC price in dollars).
dzungmobile
Sr. Member
****
Offline Offline

Activity: 714
Merit: 369


I stand with Ukraine!


View Profile
January 28, 2023, 09:32:14 AM
 #10

Bitcoin price ticker extension.

Some past requests

From available extension, you will have to convert date time from Epoch format to human-readable format so let's check A guide to quoting posts in locked topics

███████████████████████████████▀▀▀▀
███████████████████████████████
█████████▀▀▀▀▀█▀█▀▀▀▀▀█████████
███▄▀▀▀   ▄▄▄▄   ▄▄▄▄   ▀▀▀▄███
███████▀▀▀████▌ ▐████▀▀▀███████
█████▀███▀█▀██▌ ▐██▀█▀███▀█████
███████▀▄▀▄███▌ ▐███▄▀▄▀███████
█████▄██▄██▄██   ██▄██▄██▄█████
███████▄▄▄████   ████▄▄▄███████
██████████▀▀▀▀   ▀▀▀▀██████████
██████████▄▄▄▄▄▄▄▄▄▄▄██████████
███████████████████████████████
███████████████████████████████▄▄▄▄
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
.
TRUST DICE
.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀█











▄▄▄█
█▀▀▀











█▄▄▄
#1 RATED CRYPTO
CASINO IN THE WORLD
██ ██ ██ ██ █Trustpilot
▀▀▀█











▄▄▄█
▄█████████████████████████████
██████████████████▀▀█████▀▀████
█████████████████▀█████████▀███
██████████████████████████████
███████████████████████████▄███
█████████████████████████▄▄████
███████████████████████████████
█████████████░░░███████████████
███████████░░░█████████████████
█████████░░████████████████████
█████░░░██████████████████████
███░░█████████████████████████
▀░░░█████████████████████████▀
█▀▀▀











█▄▄▄
▀▀▀█











▄▄▄█
Husires
Legendary
*
Offline Offline

Activity: 1596
Merit: 1284



View Profile WWW
January 28, 2023, 08:16:59 PM
 #11

Such great ideas can be implemented unofficially using either User-scripts or third party services.

User-Script:
If you are a developer, it will be easy for you to write a user-script code where once you click on the bitcoin price or the price next to the bitcoin symbol or any number, the script will take the date of the topic and then give you the bitcoin price at that time.

Third party apps like https://ninjastic.space:
You can ask @TryNinja to add this feature to ninjastic.space, and he may be do it if he has a free time

The challenges is that the price of Bitcoin in the first three years was not as easy as now, and I do not know if there is historical data for the price before 2011.

.BEST..CHANGE.███████████████
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
███████████████
..BUY/ SELL CRYPTO..
tranthidung
Legendary
*
Offline Offline

Activity: 2268
Merit: 4000


Farewell o_e_l_e_o


View Profile WWW
January 29, 2023, 03:55:59 AM
 #12

Such great ideas can be implemented unofficially using either User-scripts or third party services
Partially you have it with small products from BlackHatCoiner, there

Disadvantage:
  • It shows the image with value of a bitcoin amount with current price, not with past price.
  • So if you need to have it for today price of 10,000 BTC to buy 2 Pizzas, it serves you well.
  • If you need something to show value of 10,000 BTC at the time of 2 pizzas deal, you will need something different, a modification of it maybe

Example for today value of 10000 BTC  Cheesy

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
Husires
Legendary
*
Offline Offline

Activity: 1596
Merit: 1284



View Profile WWW
January 29, 2023, 11:22:31 AM
 #13

Partially you have it with small products from BlackHatCoiner,
If there is historical data, the code can easily be modified to show the price on a specific date, but it will not be able to fetch the date of the topic, meaning this solution is suitable for current and future topics, not in the past.

The only solution is a userscript to display the price at the time of topic created.
If there is demand for such scripts, I can try to write something. Grin

Off-topic: Are there really people who read old topics? they will be archived, except for specific topics.

.BEST..CHANGE.███████████████
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
██
███████████████
..BUY/ SELL CRYPTO..
npuath (OP)
Copper Member
Jr. Member
*
Offline Offline

Activity: 42
Merit: 67


View Profile
January 29, 2023, 10:56:23 PM
 #14

The only solution is a userscript
Surely not the only, see my updated first post for an external server side demo solution.

Off-topic: Are there really people who read old topics? they will be archived, except for specific topics.
A few at least, user xtraelv created a great topic The most iconic bitcointalk threads. History on Bitcointalk.


LTU_btc
Legendary
*
Offline Offline

Activity: 3052
Merit: 1330


Slava Ukraini!


View Profile WWW
January 29, 2023, 11:35:40 PM
 #15

That's interesting idea.I don't think that it should be added to forum by theymos, after all, it's not very beneficial for forum users and question how many would use it. But it would be cool to add such feature to one of current Bitcointalk extensions.

Bitcoin price ticker extension.

Some past requests
Well, it's not same things that OP offered. In examples given by you people ask to real time Bitcoin price ticker and OP is talking about showing past prices.

BenCodie
Legendary
*
Offline Offline

Activity: 1638
Merit: 1036

6.25 ---> 3.125


View Profile
January 31, 2023, 08:26:35 PM
 #16

This would be fun. Even having the bitcoin price next to the post date in each post would be cool. Imagine if you could see the bitcoin price at the time of every single post? Of course it is impractical due to the amount of resources this functionality would take, but still a fun idea to think about and visualize.
npuath (OP)
Copper Member
Jr. Member
*
Offline Offline

Activity: 42
Merit: 67


View Profile
January 31, 2023, 08:47:12 PM
Merited by BenCodie (3)
 #17

It is rather cool, try it out yourself: https://ztt.se/test:bct_pdq/index.php?topic=5436755

BenCodie
Legendary
*
Offline Offline

Activity: 1638
Merit: 1036

6.25 ---> 3.125


View Profile
January 31, 2023, 08:58:51 PM
 #18

It is rather cool, try it out yourself: https://ztt.se/test:bct_pdq/index.php?topic=5436755



That is awesome. I guess it doesn't take as much resources as I thought. I suppose if you made it a SMF 1.x.x compatible modification and published it on simplemachines.org, Maybe there is a good chance that it could actually be implemented easily by theymos.
npuath (OP)
Copper Member
Jr. Member
*
Offline Offline

Activity: 42
Merit: 67


View Profile
January 31, 2023, 09:07:31 PM
 #19

It's actually a live proxy.

I've disabled the login and register pages so that nobody accidentally tries to login.

BenCodie
Legendary
*
Offline Offline

Activity: 1638
Merit: 1036

6.25 ---> 3.125


View Profile
January 31, 2023, 09:13:40 PM
Merited by npuath (3)
 #20

It's actually a live proxy.

I've disabled the login and register pages so that nobody accidentally tries to login.



Good idea Smiley Take a look at this thread...I am not sure if it is just me though around 4/5 of the posts are not showing the price. I thought it might be after someone gives merit however it seems that there isn't a pattern to reason why it does that. My only thought is maybe after some consecutive posts of the same price it doesn't show? Or is the price added to the posts after some period of time?
Pages: [1] 2 »  All
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!