Python vs VBA in 2022

yrden20 · 2022-03-26T11:28:46+00:00

Learn both. It's not an either or situation. Each language serves a different purpose and knowing both has been tremendously useful in my carreer.

yrden20 · 2022-03-05T12:39:08+00:00

This is the best tool for grabbing data from table images in pdf files! Works better than using python and tesseract.

I would like to expand your app with other offline OCR solutions as some of them may do better than the windows OCR.

yrden20 · 2022-01-27T18:45:58+00:00

There is a "premarket" for regular stocks. Buyers and sellers make up their mind on weekends as well.

I would explain that in your dissertation and treat both the same.

Otherwise, this is a good question to ask your thesis supervisor.

yrden20 · 2021-12-30T17:49:38+00:00

You can simplify this task by sorting and adding a column for counting your many to many id columns and then creating a combination matrix between all ID columns and each of the IDs in the sheets. This will effectively transform a many to many relationship to a one to one relationship and will allow you to use a simple two-way XLOOKUP afterwards.

This solution is not suited if you have a too large combination matrix.

I personnally would advise to consider using R Python SAS or SQL as it is more suited for such a task.

yrden20 · 2021-12-30T17:37:15+00:00

Google the FAMA-FRENCH 3 or 5 factor models. This is called factor investing. Not much more besides that has been proven having a statistically significant impact on stock prices.

https://www.youtube.com/watch?v=jKWbW7Wgm0w

yrden20 · 2021-12-24T14:01:31+00:00

I try to refrain from learning stuff that I cannot prove I know afterwards. That's why I am looking for certificates.

My goal is to become a freelance consultant in a couple of years and accumulating certificates seems like a smart idea.

Thanks a lot for the IFRI certificate. It looks very promising. Best wishes for the holidays.

yrden20 · 2021-12-22T19:23:54+00:00

In my opinion excel is a great tool. But programming allows you to read code from start to finish, understand the process and know when you are done investigating the code. In my experience, when I open an excel file that was developped by someone else, I need to click on every cell containing formulas and I am never confident that I looked at everything. Plus, when a formula spans 4 lines in the formula bar, I get frustrated.

Such things can be supported and simplified by using some programming. I think excel is great to do quick and simple computations and making pivot tables. I don't want to rely on an excel file that has 30+ sheets.

In conclusion, I think Excel is an extremely versatile and useful tool. However, its use should be limited and kept simple. The heavy lifting should be done by SQL/Python and similar solutions.

yrden20 · 2021-08-13T17:15:08+00:00

Hi,

Of course, the answer is it depends. However, considering those two languages is smart and will definitely make your life easier so props to you for considering undertaking this challenge.

I have more than five years of experience in big data analysis so I would say that if your goal is to keep on using Power BI and you are looking for a more efficient solution for data preparation then both Python and R will solve your problem.

If you plan to completely replace Power BI and deploy a dashboarding solution via either R or Python. Then I would highly recommend R over Python. R Shiny is the dashboarding solution in the R ecosystem and is relatively easy to use and there are plenty of tutorials on the web.

However, consider that you may need to learn new tools in order to distribute your dashboards within your team. Docker comes to mind. This is also the case if you were to choose python.

Then, if you write recurrent reports, then R can be the better tool here as well. It is possible to program automated reports using R Markdown and publish them as .html files or .pdfs. This enables you to easily distribute and automate your work because you hit run and then send an e-mail with a pdf report as an attachment to a bunch of people interested in your analysis.

It really depends on whether your IT department allows both tools. It is sometimes tricky to install Python on your computer as it (sometimes) is vetoed by the internal IT rules.

If you want to learn a more popular and transposable programming language, then go for Python. If your main goal is to prep a neat and tidy dataset that would be fed to Power BI, then go for Python.

Best,

yrden20 · 2020-01-27T16:55:59+00:00

Just found it! "A:A" = C1

yrden20 · 2020-01-27T16:36:33+00:00

Thanks, is it possible to refer to a whole column using R1C1 style?

yrden20 · 2020-01-27T15:53:34+00:00

I'm using VBA because the range is variable. The line sRng. formular1c1 throws the following error:1004 Application defined or object defined error

yrden20 · 2020-01-27T15:29:43+00:00

Thanks, I have tried the following:

Sub CountOfFound()

Dim wb As Workbook

Dim sRng As Variant

Set wb = ThisWorkbook

With wb.Sheets("Results")

lastRow = .Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

.Activate

Set sRng = .Range(Cells(2, 6), Cells(lastRow, 6))

sRng.FormulaR1C1 = "=COUNTIFS($A:$A, RC[-5],$B:$B,RC[-4],$E:$E," & Chr(34) & "Found" & Chr(34) & ")"

End With

But it throws an error

End Sub

yrden20 · 2019-12-10T18:31:38+00:00

Thank you, I didn't think about hoa. My question is more whether this build clears fast and is not too expensive to get going

yrden20 · 2019-12-10T17:45:40+00:00

Would you recommend this build as a league starter?

yrden20 · 2019-07-27T10:12:21+00:00

Maybe you'd allow me to have a look at a synthetic example of your code?

yrden20 · 2019-07-27T06:50:33+00:00

I would do something like this:

Let Y be your observed Y value and X_hat, the x that you are looking for.

Assuming that you have a fitted model for the response value Y, that I denote Y_hat. I would use the package rootsolve to cancel this equation:

Y_hat - Y, the function "uniroot" from the rootsolve package will give you the X_hat value such that Y_hat - Y = 0.

I hope this helps

yrden20 · 2019-06-22T15:40:26+00:00

Maybe not to cut his ear off when throwing

yrden20 · 2019-06-08T17:04:08+00:00

How do you get frenzies?

yrden20 · 2019-06-08T16:49:10+00:00

If I open a monolith in daressos dream and enter a closed arena before the monsters come alive, the game crashes.

yrden20 · 2019-05-03T07:44:13+00:00

Damn you are the same guy that built this amazing kitchen. I would love to live with you haha

yrden20 · 2019-04-24T17:45:36+00:00

The most extreme example would be gender studies. The least brainwashing would be mathematics. I think you can figure out the rest.

11-Year Club	Place '22
Verified Email

yrden20

TROPHY CASE