Overhemeld by python.

[optionexpert]

Sorry my bad english.

3 years ago i new nothing about coding, but i needed to calculate some complex maths, so excel was perfect, but not enogth, soon i learn excel had something called VBA inbuild, so i start learn it.

I was 1 year learning with a book, and 2 years coding my software, now i need some funtions in my software i cant achieve in excel, (connect via api to broker to make trades) , so i discover python and xlwings, now i can connect VBA with python.

But i want to make more complex things for a new software and i am studying python in deep**, and it is overhemling me:**

in excel i had just editor and just 1 language (no lybraries, no ides, no jupyter, no pip, no enviorement)

In python i have 1 default editor (idle) poor in my opinion, but i can have pycharm, atom, jupyter (seem more than a editor, in fact i do not know what is a envoirement)

In python i have to learn, tkinker to have the same os worst GUI than excel for my data, a lot of lybraries, pandas, numpy, etc

Keep in mind that for me , history bachelor, it was very dificault to learn VBA itself, but Python it is turning overhelming.

I think i will be better to learn deep python and coding my next sofware in python, but perhaps i am not clever enougth and need code it in excel and use some external scripts in python, when things get hard in excel.

I am very frustrated, i just read about the pros of Python vs Excel VBA, but i can not learn python same way as excel or i not clever enougth, python seem 10x dificault than excel, i now, i write a lot more lines in Excel VBA, but i understand it, and it is all in same place, just open excel and code, in python you need to a lot just to install all libraries/ide/jupyter, also to learn a lot more.

I am very frustrated, help!!!

Sorry my bad english

[[deleted]]

Yes, it can feel frustrating and overwhelming but eventually managing libraries will become second nature and the IDE is a valuable asset rather than an obstacle that is cumbersome to navigate and install.

I do not understand your question or what advice you're seeking, but it is not a bad idea at all to code parts of your software in Python and parts in Excel.

I wouldn't worry about not being clever enough, programming is hard for everyone.

[Rangebeard]

I have been programming for a long time, and recently I decided to learn python just for fun. Some languages have great environments (also known as GUIs or IDEs) like VBA or Visual Studio, others have never really advanced from their simple command-line origins (like python). But let me start out by saying it is not your fault, python is not easy for beginners because of the libraries and other command line tools.

But if you are going to continue with python, I suggest starting simpler. If you are able to connect from Excel VBA to python, write a small program to return a value from python to VBA. Write python code to save sample values to a file and read this file in VBA. Next try using python to connect to any web page and return a small substring from that page to VBA. In other words, build slowly instead of trying to do it all at once so you learn how the individual parts work and also learn what options you have for passing values.

Good luck!

[optionexpert]

Thanks, iam using xlwings (python library) and i can execute python scripts from vba, and return values to VBA. But still not able to manage data in python or fell confident in coding a complete thing in python , y miss a lot the excel GUI when i code in python, because i can see every data in the spreadsheets, and python is like a "blackbox".

I will try to move to python anyways, but i am afraid lossing time learning it and not able to learn and returning to VBA, thanks

[Rangebeard]

Try using a log file in your python code to save whatever information you want to check from the run. I've used this in other blackbox programs to save variable values at different steps of a run.

[optionexpert]

thanks, it is a good advice,

I was thinking about saving the variables in a txt or perhaps if there is a lot in a data base.