DAS - Dynamically Calculate Shares on %Risk or $Risk - Hot Key + Configuration, Updated 9/10/19, v2.1

[DAS - Dynamically Calculate Shares on %Risk or $Risk - Hot Key + Configuration, Updated 9/10/19, v2.1]

1 hour ago, Jason W said:

Thanks again for this amazing script.  

 

I download this sheet as .xlsx on my computer, it needs to ENABLE EDITING to change the value. But after I enable editing, the spreadsheet stop working.  

 

Is there anyway to fix this ? 

 

Thank you 

I had the same issue. It seemed to me that the calculations only work in the google spreadsheet. 

[DAS - Dynamically Calculate Shares on %Risk or $Risk - Hot Key + Configuration, Updated 9/10/19, v2.1]

This is brilliant. I am going to define my hotkeys using your script template and try it in my simulator (this is my 2nd week in the simulator). 

I think there is one caveat of the script which I describe below. Please correct me if I am wrong.

When calculating the number of shares one could afford with current account buying power:(e.g. DefSahre = BP*0.98), your script would be using the "stop loss" price instead of actual bid/ask price. This difference would lead to not having enough buying power when going for a long position with current account buying power. I guess you must have realized that and hence set 98% of total buying power as default. I could not think of an easy way to deal with this issue as we do need the stop loss price in the calculation. But I think this could be listed as "know issues" of the script to warn potential users. 

(Additional note: DefSahre = BP*0.98: This was confusing to me at first: how could buying power ($) multiple 0.98 is equal to share number?. After I checked the Dastrader manual and realized that it was actually calculating BP*0.98/Price. This was really Dastrader's fault. I share this here in case other users had the same confusion.)