Wasn't exactly sure how to post a table, but here is an attempt at a table:
B C D E F G H I J Date Trans Type Symbol Shares Price Total TransID Blocks Sold Profit & Loss 1/5/15 buy goog 100 500 50000 3 1/6/15 buy goog 100 500 50000 4 1/10/15 dividend goog 5 505 2525 5 1/14/15 sell goog 205 520 106600 6 3,4,5
Basically, I need to know how to read in the values of 3,4,5 in I6 to calculate my P&L. This is similar to for loops (for iin $variable, do) Bash Scripting (not sure if there are any Linux user on this forum).
Bookmarks