How to get values from accounts tab and write to csv

[conjure]

Hi.
I m trying to make a strategy to export
Balance , Equity , Used Mr , Usable Mr %
from Accounts Tab and export it to a .csv using comma,
so i can import it to Google Chart API and make a diagram of my accounts activity.

Can someone help me with the code ?
Can i also add a delay of 5 minutes so i don't end up with a huge file
Can i also store the .csv file to path C:\xampp\htdocs ?

[conjure]

I found a way...

Code: Select all


function ExtUpdate(id, updatedSource, period)
 
   
       local account = core.host:findTable("accounts"):find("AccountID", Account);

      


file = io.open(instance.parameters.File.. ".csv", "a");

Balance=math.floor(account.Balance)
Equity=math.floor(account.Equity)
Used=math.floor(account.UsedMargin)
Usable=math.floor(getUsableMarginPercent())

    file:write(now);
    file:write(",");
    file:write(Balance);
    file:write(",");
    file:write(Equity);
    file:write(",");
    file:write(Used);
    file:write(",");
    file:write(Usable);
    file:write("\n");

      file:close()



end

function checkAccountRow()
    if mAccountRow == nil then
        mAccountRow = core.host:findTable("accounts"):find("AccountID", mAccount);
    else
        mAccountRow:refresh();
    end
end


function getUsableMarginPercent()
   checkAccountRow();
   return (mAccountRow.UsableMargin / mAccountRow.Equity) * 100;
end


function getUsableMargin()
    checkAccountRow();
    return mAccountRow.UsableMargin;
end