import csv
import math

i = 0

with open("vector_20240822.csv") as file_new:
    i = sum(1 for line in file_new)

print(i)

row_index_new = 1
row_index_old = 1


with open("vector_20240822.csv") as file_new, open("vector_resultado_rendimiento.csv","w") as file_result:



        reader_new = csv.reader(file_new)

        writer = csv.writer(file_result)

        writer.writerow(["TV","Emisora","Serie","Ticker","PrecioSucio24Viejo","PrecioSucio24Nuevo","Rendimiento"])


        for row in list(reader_new)[1:]:

            col_c_new = row[2]
            col_d_new = row[3]
            col_e_new = row[4]
            col_k_new = row[10]
            col_n_new = row[13]

            price_new = col_k_new

            ticker_new = col_c_new+"_"+col_d_new+"_"+ col_e_new

            #print(ticker_new)

            #print(f"Indice del archivo NUEVO = {row_index_new} ")

            row_index_new += 1

            with open("vector_precios_antiguo.csv") as file_old:

                reader_old = csv.reader(file_old)

                for row_old in reader_old:

                    col_c_old = row_old[2]
                    col_d_old = row_old[3]
                    col_e_old = row_old[4]
                    col_k_old = row_old[10]
                    col_n_old = row_old[13]



                    ticker_old = col_c_old+"_"+ col_d_old+"_"+ col_e_old

                    if ticker_new == ticker_old:

                        price_old = col_k_old

                        if float(price_old) != 0.0:


                            rendimiento = ((float(price_new)/float(price_old))-1)*100

                            print(f"El precio viejo es: ${price_old} , el precio nuevo es : ${price_new}. Con Rendimiento = {rendimiento}")

                            writer.writerow([col_c_old,col_d_old,col_e_old,ticker_old,price_old,price_new,rendimiento])



                        break

                    #print(f"Indice del archivo viejo: {row_index_old}")
                    row_index_old += 1