Jump to content
jonosg

Automate reporting in DAS

Recommended Posts

Hi All,

I've put my playbook / journal in an MS Access database - I was wondering if anyone has a way of automating getting the account, positions and daily market viewer out of DAS. The only way I can find to do this is by clicking export on each window separately and then typing in a name and it saves them in the das directory as .csv files. The access db automatically  queries the .csv files, uploads the data then deletes them but I can't find any hotkey or automatic process for creating them, its not really a big deal but sometimes I forget to do it.

Does anyone have a VBA, Python, C# etc script that will allow access or excel to pull them directly from DAS or a means of getting DAS to automatically generate the .csv files they care to share - if not I'll speak to DAS support.

Share this post


Link to post
Share on other sites

@fab has actually created a useful and extremely simple AutoHotKey script to automate exporting the Market Viewer window! You could easily change the script to adapt to the windows you want exported instead 🙂

You sound pretty savvy already, but let me know if you need help with it!

 

  • Like 1

Share this post


Link to post
Share on other sites

Thanks Justin, I tried searching the forums before posting but couldn't find anything. I have not used AutoHotKey for about 15 years, I'd completely forgotten about it. Should be able to cobble something ugly together - programming wise I know enough to be dangerous.

  • Like 1

Share this post


Link to post
Share on other sites
On 3/26/2020 at 7:30 AM, jonosg said:

Thanks Justin, I tried searching the forums before posting but couldn't find anything. I have not used AutoHotKey for about 15 years, I'd completely forgotten about it. Should be able to cobble something ugly together - programming wise I know enough to be dangerous.

Hi, if the SQLite format is ok for you this application:

reads the DAS logs and saves them in a SQLite DB, which you could use to get the information about the orders and join them with the watchlist info.

In the DB for each order you would find this info:

image.png.66fa414158fa49861c8414c0854484b1.png

If you want to integrate this in a script I don't see any problems in making the DB creation available from command line.

Share this post


Link to post
Share on other sites

Hi Fabio,

Sorry about the delayed response, I'll check it out, may have saved me some time and effort if i'd checked this post earlier. My app is Access / Excel / VBA but does something pretty similar and uses a Powershell / Gnunix script to parse the DAS log files and upload the relevant changes into the database tables (using an ADO command). The AutoHotKey script was very useful - thanks.

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.