Hi all!
Is it possible to make a script that would update a price based on a variable? I'll explain: The spot price on silver changes every minute. I sell silver bullion for let's say $2.50 over spot. The script would check for changes in the spot price every minute, add my $2.50 markup, and then adjust the price accordingly directly on my website. I also need an option to easily change/edit the markup in the script. The script must also calculate the price based on discounts:
5-49 (basic price)
50-99 (5% discount, editable)
100-499 (7% discount, editable)
500 or more (9% discount, editable)
So, if the editable part in the script looked something like this;
[spot] + (markup) 2.50 * (amount) 49 = [price]
[spot] + (markup) 2.50 * (amount) 99 / (discount) 5% = [price]
[spot] + (markup) 2.50 * (amount) 499 / (discount) 7% = [price]
[spot] + (markup) 2.50 * (amount) 500 / (discount) 9% = [price]
I don't know any programming and if this is possible at all, so I thought this might be the right place to ask. Am I way off on what can be done in programming here?