I see reading your HYPTUSS helpfile that it looks as though you are obtaining your prices from yahoo, is that right ?.
In the past when their webservice was still working I used to use that, but since its been shutdown I have had to go elsewhere.
How are you obtaining your prices from yahoo exactly, if you dont mind me asking. And are they real-time or 15 minute delayed or something else ?.
We probably keep forgetting that newcomers might not be aware of the 'open source
' nature of this HYPTUSS project, and that we're really quite happy for you to go and dig around in the VBA if you're interested. It's all quite basic in there, and not written with any great level of efficiency in mind at all, but most of it's 'commented
' to some degree (certainly in broad 'process lumps
' at the very least..), and anyone with a passing interest in programming or scraping data should be able to find their way around the code just by double-clicking on a few of the command-buttons whilst in 'Developer / Design Mode
There's actually only a password on it at all to help stop accidental issues
happening, and we've always from day-one ensured that people are aware of the VBA password - pleaseletmein
It was clear to me from a very early stage that if this was going to be a useful tool to help people manage their investments, then there's no way we could expect people to use it for that purpose if there was anything 'hidden' in the background that might quite rightly concern people, so we've always maintained a 100% open-source approach to this project, and are quite happy and willing for people to go in there and check what's going on behind the scenes....
Getting back to the yahoo price-scrape process, it was originally
borrowed from an ex-TMF user called anc1
, who now brilliantly posts here under the name of eventide
, and he's now actually re-written
his Yahoo price-scrape process to work in a much improved way that can be incorporated into stand-alone Excel spreadsheets - you can read more about that here if you're interested - https://www.lemonfool.co.uk/viewtopic.php?f=27&t=8332
We've since updated our own HYPTUSS yahoo price-scrape processes to introduce similar methods to eventide's new script, so they are both fairly well aligned now, and you'd probably benefit from having a dig around in the code to see what's going on.
I'm always keen to help out anyone interested in the VBA side of things, as it's how I learnt originally myself, so if you're wanting to discuss anything specific then I'm more than happy for you to PM me, or start a separate VBA thread on the Financial Software Board, and we'll try to help out as much as we can if this is something you're keen to pursue. .
Given that we're discussing the yahoo price-scrape process, I'll end my post with my very grateful thanks
for coming up with his price-scrape process, because it was that bit of VBA that actually kicked me off into orbit regarding this whole project, and if that original routine hadn't existed, I have no doubt at all that HYPTUSS would simply never have seen the light of day all those years ago....