LiveCode Forums

The client wants: if someone put "X" amount of money in their 401K, every two weeks, bi-weekly, can you tell me what balance they would have after a period of years. This would need to include a "dollar cost average", what I mean, is when the stock market goes down, they are buying more shares. Some...

How would one go about creating a livecode program from an excel spreadsheet while preserving the formulas and math?

Mike

As the title suggests, has anyone coded a 401K calculator with dollar cost averaging in LiveCode?

Mike

For the tax issue, just limit the addition to the cases where it's really a number (no try structure needed this way) : if tSalesTax is a number then add tSalesTax to tTotalSalesTax Did not work because there are numbers in these strings. Example of strings that are causing trouble: KZX9VLWATAXE8 b...

Klaus,

I just PMd you with the file.

Thanks again.

Mike

Hi Mike, this is getting way too abstract to "cure" from afar 8) Maybe you can supply a sample stack with some example data, so we can check what's going on? Best Klaus Klaus, What is your email address and I will be happy to send you the project file. It has sensitive data in it, so I cannot just ...

Amazing. Never even heard of the Try command. Honestly, it does work, but adding up all the sales tax is not correct. It seems to be adding values even if it's a string???? if t[tNum] contains "tax" then put t[tNum] into taxVar set itemdel to "=" --This goes into the Data Grid Array put item 2 of ta...

Hi Mike, add tSalesTax to tTotalSalesTax but that did not work. maybe you could be a TAD more precise? Syntax is correct, so what exactly does not work? 8) Best Klaus Klaus, I corrected myself when I realized it was a error due to a string creeping in (scroll all the way to the bottom to see the st...

Going through the sales tax array, an error popped up because a paypal line had the word 'TAX' in it, but it was NOT the sales tax, as a result, it crashes because it cannot add the value. Here is the list of sales tax numbers (scroll all the way down to see the problem): 5.60 6.44 7.14 2.80 11.20 1...

Shouldn't this read: ... if t[tNum] contains "payment_date" then ## put t(tNum) into payVar put t[tNum] into payVar ... ? OMG!!!!!!!! That's what programming till 4am does to you. I NEVER would have seen the () instead of the [] Sheesh! That, of course, fixed it now that you pointed out my blunder....

Thank you, however, why does the following give me a execution error: --==================================== --Main Loop --==================================== put 1 into col1date put 1 into col2tax answer "Begin Processing Orders" repeat with tNum = 1 to numlines if t[tNum] contains "payment_date" ...

I've used it once or twice but I could not really decipher it. Yes, I know. I already read all the docs. On the other hand, breakpoints are awesome. Just did not know about them till now. I have not coded in LiveCode that long and took about 3 years off of using LiveCode. Anyway, if I have a piece o...

dunbarx wrote:The next step is to put a breakpoint at the top of the block of code that loads that array variable, and make sure there is readable data in the array variable "tData"

How do I do this?

Mike

Jacque, Thank you for the advice. Quite good advice. These values are likely not going to change, but I am an idiot for not doing the if/else and the case is even better . . . DUH! However, NO DATA is showing up in the data grid. Right now that is my number one priority. How do I get it to show up i...

By the way, it looks like most of the field-intensive stuff is in your dataDump. The other fields aren't accessed that often. You can view the values of the variables in the variable watcher, without putting them into a field. I think if you just remove the data dump and keep an eye on the variable...