I was wondering if someone could explain to me why my code produces "mixed results".
Essentially the script gets a ticker id and within that dictionary, it attaches the current price and the currency type e.g USD, GBp etc.
tickerDict[result[row]] = {currentPriceData , currencyType[37:]}
Essentially the output I would like is Ticker, Price, Currency. But I noticed when looking at the output in excel the price and currency could be mixed for example:
Ticker, Price Currency
ABC,5,USD
DCD,5,EUR
ADF,USD,5
FGA,5,GBP
AFA,GBp,5
I fixed the code by using the following Line
tickerDict[result[row]] = {currentPriceData : currencyType[37:]}
However, just for my better understanding of how code works why was the first method returning results in different orders?