search

getstrake / aws-pricing-sheets-addon

Google Sheets add-on for AWS Pricing
https://workspace.google.com/marketplace/app/aws_pricing_by_strake/378787760903
33 stars 0 forks source link

Support for historical price points #28

Open thomas0376 opened 1 year ago

thomas0376 commented 1 year ago

I believe the AWS Bulk API supports historical price points, it would be good to have this functionality being carried over to this add-on

reganbrianpatrick commented 1 year ago

@thomas0376 Thank you for this feedback! This is something that has come up from multiple users.

When we're thinking about how to show historical pricing data, a couple of questions come to mind: -- How far back in time would it be valuable to have pricing? -- Would you want to see pricing by a calendar date or by seeing the last previous price points regardless of the date? (current price = n, previous price = n-1, etc.)

thomas0376 commented 1 year ago

@reganbrianpatrick Glad to hear I'm not the only one, historical pricing is useful for many purposes: -- I'd value the ability to see the history as far back as AWS allows it. If this add-on is based on the AWS Bulk Pricing API, I believe AWS let you specify the date the price was in force. -- I'd like the ability to pass the date as a parameter, possibly in the format "YYYY-MM-DD"