ScriptSnippets

Twisty TOC code

%TWISTY{mode="div" showlink="Show the table of contents..." hidelink="Hide" remember="on" showimgleft="%ICONURLPATH{toggleopen-small}%" hideimgleft="%ICONURLPATH{toggleclose-small}%"}%
%TOC%
%ENDTWISTY%

Table Definitions

• subheading

Edit Table Definitions

• -

Matching Table and Edit Table Definitions

From ROI Tool

%TABLE{ sort="on" initsort="1" tableborder="0" cellpadding="1" cellspacing="3" headerbg="#D5CCB1" headercolor="#666666" databg="#FAF0D4, #F3DFA8" headerrows="1" footerrows="0" headeralign="center, center, right, right, right, right, right, right, right, right, center" dataalign="center, center, right, right, right, right, right, right, right, right, center" }%
%EDITTABLE{changerows="on" header="| *Row* | *Date* | *Deposits* | *Cash Value* | *Stock Value* | *Margin* | *Shares* | *Per Share* | *ROI $* | *ROI %* | *Time Stamp* |" format="| row, -1 | date, 25, , %m/%d/%Y [%H:%M] | text, 10, 7572.61 | text, 10 | text, 10 | label, 10, $percntCALC{$quot$dollarFORMAT(NUMBER, 2, $dollarEVAL(($dollarT(R$dollarROW():C$dollarCOLUMN(-2)) - $dollarT(R$dollarROW():C$dollarCOLUMN(-1)))))$quot}$percnt | text, 10, 800 | label, 10, $percntCALC{$quot$dollarFORMAT( NUMBER, 2, $dollarEVAL( $dollarT(R$dollarROW():C$dollarCOLUMN(-3) ) / $dollarT(R$dollarROW():C$dollarCOLUMN(-1)) ))$quot}$percnt | label, 10, $percntCALC{$quot$dollarFORMAT(NUMBER, 2, $dollarEVAL(($dollarT(R$dollarROW():C$dollarCOLUMN(-5)) - $dollarT(R$dollarROW():C$dollarCOLUMN(-6)))))$quot}$percnt | label, 10, $percntCALC{$quot$dollarFORMAT(NUMBER, 2, $dollarEVAL(($dollarT(R$dollarROW():C$dollarCOLUMN(-6)) - $dollarT(R$dollarROW():C$dollarCOLUMN(-7))) / $dollarT(R$dollarROW():C$dollarCOLUMN(-7)) * 100 ))$quot}$percnt | label, 0, %SERVERTIME{"$day $mon $year $hour:$min"}% | "}%

Spreadsheet Formulas in EditTable formatting

Subtract Two Columns Within Same Row - Dollar Formattting

Spreadsheet Formulas within cells

Subtract Two Columns Within Same Row - Dollar Formattting

Table Footers

Column Sums With Dollar Formatting (from credit managment tool)

Sum the 12 column with Dollar Formating

Begin Topic

Comments

-- LorenAlbert - 28 Apr 2007