I used to manually create charts (sort of like what bones used to post), that showed a normal chart, but with daily shorts and short interest included, in a format that was 'nice to the eye'. I want to do it again, but using a semi-automated process instead of a totally manual process.
So I was merging free data from 'ASX historical data', 'ASX daily shorts' & 'ASIC short interest', then putting it all into Microsoft Access (which I have never used before) to build a database, and then using Excel to access the Access Data, and draw the chart for me.
I needed it to be a fairly quick and easy process, as I would be doing a manual 'copy and paste' to load daily for the short data, and weekly for the ASX data.
And I needed it to be easily updatable after I get back from being away....well relatively easy anyway.
I struggled a bit using Access, I should have probably just played around with it first, and learned how it worked, before jumping in with a complicated process.....but what the heck, I just googled the problems when I couldn't make it work, and solved a few problems by myself, and worked with a steep learning curve.
And I almost got it sorted, but I had a formatting issue from the ASIC data which I couldn't get around.
But I think I know why it happened now, so I will have another go soon.....I just need to get over the trauma of it failing the first time around......haha
cheers
- Forums
- Test
- Rav's Office
Rav's Office, page-1357
- There are more pages in this discussion • 167 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Featured News
Featured News
The Watchlist
ACW
ACTINOGEN MEDICAL LIMITED
Steven Gourlay, CEO
Steven Gourlay
CEO
Previous Video
Next Video
SPONSORED BY The Market Online