I majored in Finance/ minored in Economics. My wife majored in Macroeconomics w/ a masters in Applied Economics. We're in the US, so our experience may not relate exactly to your situation..
First, do what you think you'll enjoy. You can make plenty of money either way - especially if you implement the MMM philosophy early on...
Finance: If you like the stock, bond, investing route - go with finance & get a job with a money manager. I know you fear automation, but IMO, capital management aint going away. The whole EMH debate has raged on since the 60's, and now it's morphed into an active vs. passive debate with computers & algorithms coming into the mix. These days the EMH camp definitely has the momentum, but the market has gone straight up for the last 5 or 6 yrs. Give it another good recession and people will again proclaim "Buy & Hold is dead!!". Maybe not most ppl on this forum, who tend to be quite educated on the subject, but most ppl will. Just wait. These things move in cycles. Furthermore, the bulk of institutional money, sovereign wealth and hnw individual wealth is not in the vanguard 500 fund. It's spread out among holdings in private placement funds, lp's, equity, real estate, debt instruments, etc, etc, etc. If you want to get into finance & investing, opportunity abounds. Don't let that be a concern. Of course, with a finance degree you aren't just limited to money management. You could get into consulting, M&A's, capital markets/investment banking... many other opportunities.
Applied Economics: You will have no trouble finding a job today with this major. Basically every corporation and government in the world is building out a team of millennials proficient with Excel, SAS, or some equivalent program to analyze data, make projections & forecast. Opportunity for advancement may not be quite as strong. I.E. you probably won't get "rich" doing this. But the starting salaries are among the highest around, and you'll have job security at least for the foreseeable future.
MacroEconomics: A very interesting subject, but outside of academics, I don't see many job opportunities directly related to this field. You say there are very few in your country - there's probably a reason for that. I suppose all of the major banks have a chief economist & a team of analysts, but the odds of landing a gig like that straight out of grad school could be low. You may be able to find a government job, but again, it's hard to place value on simply having a bunch of knowledge about various economic theories and principles. There definitely is value in having that knowledge, but the jury's out on whether the job market will adequately compensate you. With this major, the surest path would be to become a professor - good quality of life, good pay, lower stress.
Hope this perspective helps.