(Feb-15-2021, 06:05 AM)detlefschmitt Wrote: Regarding the advice to read the csv file into python rather than using Excel VBA to create a string that then needs to be pasted into the python script. That I do not consider an advice. It should be obvious to anybody with just a little programming skills that that is possible and more efficient. As I explained in my now removed post, due to private matters posted, I was just not willing to spend the time figuring out how to do it. I had other priorities. Writing the VBA took me a couple minutes. But eventually my curiosity took over and I did put in the work to learn how to do it in python. Figuring out how to read the csv and that I need to convert the ticker column to a list before it can be further processed took me a couple hours. If I would have been given an example on how this is done conceptually I could have learned it in a few minutes. That would have been advice. Yes, advice should include encouraging to think, but it should much more importantly help in speeding up the learning process. But to your defense I have to add that I discouraged you to give me advice in the form of code. But bottom line, as is, your input should, in my opinion, not counted as advice.
I did show how to read csv file. In my very first post in this thread. So, only you if did pay attention...
(Feb-12-2021, 09:47 AM)buran Wrote:import pandas as pd df = pd.read_csv('test.csv')
Then, converting dataframe column to list is google search away. Not that you need to convert to list, you can just iterate over dataframe column values.
By the way, same apply to reading from csv or excel, if you ignored my first post.
So, couple of hours spent on this is your problem, not my fault.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs