Australia's largest stock trading and investment forum Australia's #1 stock forum

Some graphic short data: https://twitter.com/AusShort Down for a...

First 1360 Last

Share
Profile

Follow
MemeFx

5,523 Posts.

31

09/11/17

23:08

Post #: 28664853
Share

Originally posted by Jako8557 ↑

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

Expand

Some graphic short data: https://twitter.com/AusShort

Down for a week or so.
Automated
This is the data source : http://www.asx.com.au/data/shortsell.txt

They could probably help with your formatting issues if you asked nicely

Mums taxi busy tonight....catch you later.

'luck with the scans.

MFx
1 Upvote

Reply