Page 2 of 5

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:00 pm
by thiru
Version 2.0

I understand that Lumios is working on a larger project where this file comes from. Since there was no need to any macros, I removed them all so the file can be made into an xlsx file. Then added some new worksheets.

Change log;
1. All macros removed and file turned into XLSX file. Just accept the excel notification and you are good to go.
2. Some cosmetic changes to the dashboard
3. Reorganized the DDE page with just the DDE data for easy of extending further by others
4. Pip value sheet now shows just the pip value, the rest of the columns are hidden
5. New sheet called, Margin requirement, this calculates the margin for all 28 pairs for the user-defined lot size and leverage.
6. Pip calculated is redesigned
7. New sheet called market range.. just to understand the moves.
8. ADR(30) need to be entered manually extracting from mt4 indicators

//
//

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:10 pm
by thiru
Jimmy wrote: Mon Jun 01, 2020 7:52 pm
Looking forward to the changes Thiru! Can you post them bro?
Just did Jimmy.. check out.. : :)

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:14 pm
by Jimmy
thiru wrote: Mon Jun 01, 2020 8:10 pm

Just did Jimmy.. check out.. : :)
Ha! This is really neat. Just recorded it, check out the gif I made of your spreadsheet. It's alive! :razz:

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:22 pm
by moey_dw
How I record with gif man it is great.................. lum & thiru u guys are genius

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:24 pm
by Jimmy
moey_dw wrote: Mon Jun 01, 2020 8:22 pm How I record with gif man it is great.................. lum & thiru u guys are genius
Use Screen2Gif it's free, portable only 1.8mb (no installation).

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:28 pm
by moey_dw
Jimmy wrote: Mon Jun 01, 2020 8:24 pm

Use Screen2Gif it's free, portable only 1.8mb (no installation).
thx.................kk here!!!!!! wowwwww :hug: :hug: :hug:

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:31 pm
by Jimmy
moey_dw wrote: Mon Jun 01, 2020 8:28 pm

thx.................kk here!!!!!! wowwwww :hug: :hug: :hug:
You've got it! Nice recording bro. How good is the ADR spreadsheet huh? :)

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:32 pm
by moey_dw
Jimmy wrote: Mon Jun 01, 2020 8:31 pm

You've got it! Nice recording bro. How good is the ADR spreadsheet huh? :)
YES I WILL KEEP THIS SHEET OPEN EVERY DAY

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:38 pm
by ChuChu Rocket
thiru wrote: Mon Jun 01, 2020 8:10 pm

Just did Jimmy.. check out.. : :)
Thiru & Lumi dudes thank you, I'm really finding Excel less distracting than charts (weird). Can you tell me, does the ADR auto update it's reading on it's own, too? Or is it static?

Re: Excel Live Trading Data

Posted: Mon Jun 01, 2020 8:41 pm
by moey_dw
Lumios wrote: Tue May 26, 2020 8:30 am Hey everyone!
dis is a top contribution here.................. seems not too enticing at first but when download & use it man i am hook................... this could plot candles i think too!!!! :think: :think: :think: