undefined | Better HN

0 pointshelsinki7y ago0 comments

Hahaha, oh wow, that's a lot of work. I think you should learn Python and some Requests...

0 comments

I don't think that would make it much simpler (if that's what you're getting at). There's tons of grunt work that just has to be done - eg. calculating expected dividend payments (by automatically matching portfolio details to dividend schedules from corporate websites), and automatically matching those to bank account credits - all through code. Despite the laughs that the VB languages get on HN, VBScript is in fact, a fully featured traditional imperative programming language, and has all the features you'd expect in such a language (but no IDE :-(). So I doubt that rewriting in python would make much difference. And I'd still be bound to the IE automation model.

A_Person7y ago

To wafflesindeed (there's no reply button):

> I'm not OP, but I suspect they meant that Python and some libraries would have solved your problem in a few days of work.

I wrote software professionally for 30 years. I have a good understanding of the work required to implement a business requirement! I cant really see myself spending 10 years on a one-week task :-)

PS. I didn't downvote you.

PurpleRamen7y ago

> And I'd still be bound to the IE automation model.

Why? You fetch data, calculate stuff and give out reports. Unless there is heavy javascript involved, you don't need a browser for any of this. But now you are dependent on the fragile setup you have created, hopping that VBScript, IE and your datasources will continue to work as long as you live.

Becoming independant and gaining a future ground would be a valid reason to change to a better environment. It doesn't need to be Python, but considering the requirements, Python is a very good choice for this it seems.

A_Person7y ago

All of the websites concerned have strict authorization requirements and none have public APIs afaics. At the start, it just seemed easiest to automatically scrape them. I guess I could have reverse engineer their private APIs and used those - but as the doctors say, the retrospectoscope is a rare and expensive piece of equipment!

1 more reply

wafflesindeed7y ago

I'm not OP, but I suspect they meant that Python and some libraries would have solved your problem in a few days of work.

This is particularly true in the UK where there's a big push for "Open Banking" where banks must provide APIs for developers.

This would remove your dependency on IE if it was all done from the command line :)

j / k navigate · click thread line to collapse

0 comments

A_Person7y ago

To wafflesindeed (there's no reply button):

> I'm not OP, but I suspect they meant that Python and some libraries would have solved your problem in a few days of work.

I wrote software professionally for 30 years. I have a good understanding of the work required to implement a business requirement! I cant really see myself spending 10 years on a one-week task :-)

PS. I didn't downvote you.

PurpleRamen7y ago

> And I'd still be bound to the IE automation model.

A_Person7y ago

1 more reply

wafflesindeed7y ago

I'm not OP, but I suspect they meant that Python and some libraries would have solved your problem in a few days of work.

This is particularly true in the UK where there's a big push for "Open Banking" where banks must provide APIs for developers.

This would remove your dependency on IE if it was all done from the command line :)

j / k navigate · click thread line to collapse