diff --git a/accloudtant/aws/reports.py b/accloudtant/aws/reports.py
index 26af2d1..905018e 100644
--- a/accloudtant/aws/reports.py
+++ b/accloudtant/aws/reports.py
@@ -16,10 +16,13 @@ class Reports(object):
 
     def find_reserved_instance(self):
         for instance in self.instances:
-            instance.current = float(self.prices.prices[instance.key][instance.region][instance.size]['od'])
+            instance_region = self.prices.prices[instance.key][instance.region]
+            instance_size = instance_region[instance.size]
+            instance.current = float(instance_size['od'])
             if instance.state == 'stopped':
                 instance.current = 0.0
-            instance.best = float(self.prices.prices[instance.key][instance.region][instance.size]['ri']['yrTerm3']['allUpfront']['effectiveHourly'])
+            instance_allUpfront = instance_size['ri']['yrTerm3']['allUpfront']
+            instance.best = float(instance_allUpfront['effectiveHourly'])
             for reserved in self.reserved_instances['ReservedInstances']:
                     if 'InstancesLeft' not in reserved.keys():
                         reserved['InstancesLeft'] = reserved['InstanceCount']
@@ -39,6 +42,8 @@ class Reports(object):
                 'State',
                 'Launch time',
                 'Reserved',
+                'Current hourly price',
+                'Renewed hourly price',
                 ]
         table = []
         for instance in self.instances:
@@ -51,6 +56,8 @@ class Reports(object):
                     instance.state,
                     instance.launch_time.strftime('%Y-%m-%d %H:%M:%S'),
                     instance.reserved,
+                    instance.current,
+                    instance.best,
                     ]
             table.append(row)
         return tabulate(table, headers)

Add price information to EC2 instances information


<!---
@huboard:{"order":6.0732421875,"milestone_order":0.09375,"custom_state":""}
-->

diff --git a/tests/aws/report_expected.txt b/tests/aws/report_expected.txt
index 928efa2..f2bbb8b 100644
--- a/tests/aws/report_expected.txt
+++ b/tests/aws/report_expected.txt
@@ -1,9 +1,9 @@
-Id          Name       Type        AZ          OS                        State    Launch time          Reserved
-----------  ---------  ----------  ----------  ------------------------  -------  -------------------  ----------
-i-912a4392  web1       c3.8xlarge  us-east-1c  Windows                   running  2015-10-22 14:15:10  Yes
-i-1840273e  app1       r2.8xlarge  us-east-1b  Red Hat Enterprise Linux  running  2015-10-22 14:15:10  Yes
-i-9840273d  app2       r2.8xlarge  us-east-1c  SUSE Linux                running  2015-10-22 14:15:10  Yes
-i-1840273d  database1  r2.8xlarge  us-east-1c  Linux/UNIX                stopped  2015-10-22 14:15:10  No
-i-1840273c  database2  r2.8xlarge  us-east-1c  Linux/UNIX                running  2015-10-22 14:15:10  Yes
-i-1840273b  database3  r2.8xlarge  us-east-1c  Linux/UNIX                running  2015-10-22 14:15:10  Yes
-i-912a4393  test       t1.micro    us-east-1c  Linux/UNIX                running  2015-10-22 14:15:10  No
+Id          Name       Type        AZ          OS                        State    Launch time          Reserved      Current hourly price    Renewed hourly price
+----------  ---------  ----------  ----------  ------------------------  -------  -------------------  ----------  ----------------------  ----------------------
+i-912a4392  web1       c3.8xlarge  us-east-1c  Windows                   running  2015-10-22 14:15:10  Yes                         0.5121                  0.3894
+i-1840273e  app1       r2.8xlarge  us-east-1b  Red Hat Enterprise Linux  running  2015-10-22 14:15:10  Yes                         0.3894                  0.3794
+i-9840273d  app2       r2.8xlarge  us-east-1c  SUSE Linux                running  2015-10-22 14:15:10  Yes                         0.5225                  0.389
+i-1840273d  database1  r2.8xlarge  us-east-1c  Linux/UNIX                stopped  2015-10-22 14:15:10  No                          0                       0.379
+i-1840273c  database2  r2.8xlarge  us-east-1c  Linux/UNIX                running  2015-10-22 14:15:10  Yes                         0.611                   0.379
+i-1840273b  database3  r2.8xlarge  us-east-1c  Linux/UNIX                running  2015-10-22 14:15:10  Yes                         0.611                   0.379
+i-912a4393  test       t1.micro    us-east-1c  Linux/UNIX                running  2015-10-22 14:15:10  No                          0.767                   0.3892

pip install -e .
parse_log_pytest
requirements.txt
pytest
apt-get update apt-get install -y gcc
3.9
requirements.txt
pytest --no-header -rA --tb=line --color=no -p no:cacheprovider -W ignore::DeprecationWarning
-e git+https://github.com/ifosch/accloudtant.git@71d752b9244ff84978a83413be84035a92d5c077#egg=accloudtant
boto3==1.37.23
botocore==1.37.23
certifi==2025.1.31
charset-normalizer==3.4.1
click==8.1.8
exceptiongroup==1.2.2
idna==3.10
iniconfig==2.1.0
jmespath==1.0.1
packaging==24.2
pluggy==1.5.0
pytest==8.3.5
python-dateutil==2.9.0.post0
requests==2.32.3
s3transfer==0.11.4
six==1.17.0
tabulate==0.9.0
tomli==2.2.1
urllib3==1.26.20

name: accloudtant
channels:
  - defaults
  - https://repo.anaconda.com/pkgs/main
  - https://repo.anaconda.com/pkgs/r
  - conda-forge
dependencies:
  - _libgcc_mutex=0.1=main
  - _openmp_mutex=5.1=1_gnu
  - ca-certificates=2025.2.25=h06a4308_0
  - ld_impl_linux-64=2.40=h12ee557_0
  - libffi=3.4.4=h6a678d5_1
  - libgcc-ng=11.2.0=h1234567_1
  - libgomp=11.2.0=h1234567_1
  - libstdcxx-ng=11.2.0=h1234567_1
  - ncurses=6.4=h6a678d5_0
  - openssl=3.0.16=h5eee18b_0
  - pip=25.0=py39h06a4308_0
  - python=3.9.21=he870216_1
  - readline=8.2=h5eee18b_0
  - setuptools=75.8.0=py39h06a4308_0
  - sqlite=3.45.3=h5eee18b_0
  - tk=8.6.14=h39e8969_0
  - tzdata=2025a=h04d1e81_0
  - wheel=0.45.1=py39h06a4308_0
  - xz=5.6.4=h5eee18b_1
  - zlib=1.2.13=h5eee18b_1
  - pip:
      - boto3==1.37.23
      - botocore==1.37.23
      - certifi==2025.1.31
      - charset-normalizer==3.4.1
      - click==8.1.8
      - exceptiongroup==1.2.2
      - idna==3.10
      - iniconfig==2.1.0
      - jmespath==1.0.1
      - packaging==24.2
      - pluggy==1.5.0
      - pytest==8.3.5
      - python-dateutil==2.9.0.post0
      - requests==2.32.3
      - s3transfer==0.11.4
      - six==1.17.0
      - tabulate==0.9.0
      - tomli==2.2.1
      - urllib3==1.26.20
prefix: /opt/conda/envs/accloudtant

tests/aws/test_reports.py::test_reports
tests/aws/test_instance.py::test_instance tests/aws/test_instance.py::test_guess_os tests/aws/test_instance.py::test_match_reserved_instance tests/aws/test_prices.py::test_process_ec2 tests/aws/test_prices.py::test_process_model tests/aws/test_prices.py::test_process_generic tests/aws/test_prices.py::test_process_on_demand tests/aws/test_prices.py::test_process_reserved tests/aws/test_prices.py::test_process_data_transfer tests/aws/test_prices.py::test_process_ebs tests/aws/test_prices.py::test_process_eip tests/aws/test_prices.py::test_process_cw tests/aws/test_prices.py::test_process_elb tests/aws/test_prices.py::test_print_prices tests/aws/test_prices.py::test_prices tests/aws/test_prices.py::test_prices_with_warning tests/test_utils.py::test_fix_lazy_json
accloudtant/aws/reports.py
accloudtant/aws/reports.py