from lxml import html
import requests
from openpyxl import load_workbook
import json
import unicodedata
import datetime

wb = load_workbook(filename='Templates/gameCrate.xlsx')

apiKey = ''
appId = ''

price_cells = []
product_names = []
product_cells = []
updated_prices = []


for i in range(1,20):
    product_cells.append("A"+str(i))
    price_cells.append("D"+str(i))
#print price_cells

for i in product_cells:
    ws = wb.active
    cell_string = ws[i].value
    fixed_string = unicodedata.normalize('NFKD', cell_string).encode('ascii','ignore')
    product_names.append(fixed_string)
#print product_names

for item in product_names:
    #print item
    apiString = "http://api.steamapis.com/market/item/" + appId + "/" + item + "?api_key=" + apiKey
    response = requests.get(apiString)
    #mytext = response.text
    parsed_json = json.loads(response.text)
    #print parsed_json
    print item, ":", parsed_json['histogram']['lowest_sell_order']
    updated_prices.append(parsed_json['histogram']['lowest_sell_order'])

mynum = 0
for i in updated_prices:
    ws = wb.active
    current_index = mynum
    print "index:", str(current_index), "item:", i
    ws[price_cells[current_index]] = i
    mynum += 1


time_stamp = datetime.datetime.now().strftime("%I%M%p-%B-%d-%Y")
save_file = "Spreadsheets/PUBG_GAMECOM_updated_at_" + str(time_stamp) + ".xlsx"