This uses the GUI for multiple inputs from the. XlSheet := XL.Workbooks.Open(Filename).ActiveSheet IfEqual, ErrorLevel, 1, Return user cancelled dialogĬalcMenu_Demo: demonstration works with first Excel file from forum Gui, Add, ListView, xs+270 ys+30 w570 h250 vLV_Pool Grid, %ColHead_Pool%įileMenu_Open: get an Excel-file's name where to read multiple inputs fromįileSelectFile, Filename, 1,Select Excel file, *.xls Gui, Add, Button, x20 yp+40 w250 h30 gClear_Pool, C L E A R Gui, Add, Button, x20 yp+31 w250 h30 gInclude_Pool, Include in List Gui, Add, Button, x20 yp-1 w100 gCalc_Pool, CALCULATE Gui, Add, Edit, yp+30 w120 Right vRes_Pool ReadOnly Gui, Add, Edit, yp+30 w120 Right vD圜_Pool Gui, Add, Edit, yp+30 w120 Right vNoD_Pool Gui, Add, Edit, yp+30 w120 Right vPoF_Pool Gui, Add, Edit, yp+30 w120 Right vDen_Pool Gui, Add, Edit, xs+140 ys+30 w120 Right vInR_Pool Gui, Add, Text, xs+10 ys+34, Interest Rate Gui, Add, GroupBox, w850 h290 cBlue Section, WITH POOL FACTOR Menu, MainMenu, Add, Calculate, :CalcMenuĬolHead_Pool := "Interest Rate|Denomination|Pool Factor|Number Days|Day Count Basis|Result" Menu, FileMenu, Add, Open *.xls file, FileMenu_Open csv, read the data with AHK, calculate with AHK, then finally write the results back to the same. But if we can select multiple data for MULTIPLE ISINs then we can calculate all required values at a time instead of putting one by one.Īs per my understanding the below comments mentioned from your end in the above post may be helpful: of days and day count) for a SINGLE ISIN which is time consuming. denomination, interest rate, pool factor, no. So, here we are considering multiple data (i.e. Descargar anysend para windows password#and open Windows 7 home premium computer without typing password com to get. Descargar anysend para windows trial#Then again i have to take each value for another SINGLE ISIN in order to calculate the value. For grammarly premium Account, grammarly premium trial Email Us : rangdhonu. of days and day count) from that excel file for a SINGLE ISIN and need to calculate with the help of the GUI. If i use our previous GUI then i have to take each of the value (i.e. We receive the excel file where n numbers of data are available for each ISIN (International Securities Identification Number) and which is unique (i.e ISIN). Like interest amount calculation (with out pool factor & with pool factor), FR calculation (repayment in cash & repayment in shares). In our daily work we need to perform some calculation which we have already shown in our previous GUI.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |