[EXCEL PROGRAMMING]
I have just spent the past while programming another add on to my Excel trade management system. I'm trying to find some info on using the integrated VB program to make part of my spreadsheet an executable file. It would save resources on my comp by having a small app running instead of starting up (or keeping up) Excel to calculate the numbers. I'm pretty decent with mental arithmetic as it is but this would just make it a little bit more mechanical for me and add more discipline to my game;
Anyway it's just a little risk reward calculator that works out my size and whether I should take the trade based on targets and stops. When I enter a trade retrospectively using the form it does this, but I don't want to have to enter and then delete those values. I have added my commission costs as part of the risk - however these are variable, and for calculation purposes are at the top end of what I would be paying for around $5000 worth of stock.
For those interested in aesthetics I have redesigned the entry form. It's a lot cleaner cut and more inspiring given that it features a made up logo of a made up company that I designed. Cool eh? I'm sure most traders don't care about that, but it's something I'm into.
Do they get The Big Issue in the States? If not you won't understand the joke in the title bar added for humour.
Anyway it's just a little risk reward calculator that works out my size and whether I should take the trade based on targets and stops. When I enter a trade retrospectively using the form it does this, but I don't want to have to enter and then delete those values. I have added my commission costs as part of the risk - however these are variable, and for calculation purposes are at the top end of what I would be paying for around $5000 worth of stock.
For those interested in aesthetics I have redesigned the entry form. It's a lot cleaner cut and more inspiring given that it features a made up logo of a made up company that I designed. Cool eh? I'm sure most traders don't care about that, but it's something I'm into.
Do they get The Big Issue in the States? If not you won't understand the joke in the title bar added for humour.
0 comments:
Post a Comment