NO LINKS, SOURCE CODE REQUESTS OR MODIFICATION OF DECOMPILED INDICATORS. To avoid post deletion please follow the rules.

Re: Excel Live Trading Data

#21
moey_dw wrote:
Mon Jun 01, 2020 8:41 pm
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:
Yep, that's why we "stickied" this post. More traders could really utilize Excel. It's very easy to set up using Lumios' steps and the spreadsheets give you the data you're looking for without lag :thumbup:
Trade with the broker that supports our work! FBS are offering $140 to get you started! Click, here to begin live trading, today.
No commissions are earned by Forex-station.


How to: Draw Fibonacci Extensions the easy way
How to: Identify major Support & Resistance using the line chart


Re: Excel Live Trading Data

#22
ChuChu Rocket wrote:
Mon Jun 01, 2020 8:38 pm
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?
Jimmy and ChuChu Rocket,

The ADR is static (unfortunately). The way I have done is, extract the ADR data from the export tool done by hanover in FF (search for that, the source code is also available).

With that, we can do any ADR, say 30, 7 etc and update the sheet accordingly. This can be done on a daily basis, at the start of the day and then you are good to go.

the indicator below;

//
//
Display Info All Pairs (build 600+).ex4
(345.31 KiB) Downloaded 193 times
//
//
adr.png

Re: Excel Live Trading Data

#23
on second thought, if mrtools or pacosis can create an indi that does the following, then we can make the ADR update procedure easy to use.

an indicator that exports a CSV file (comma separated) like this;

symbol, adr_30, adr_10, adr_5, adr_1, adr_x
EURUSD, 123, 120, 89, 98, x
...
all 28 pairs

the x value is custom and can be in input.

Then, we can just paste these values in that excel file and we can do the rest of the work automatically.

just an idea.


IdeaRe: Excel Live Trading Data

#26
thiru wrote:
Tue Jun 02, 2020 8:48 pm
Updated version 2.02

Change log;
1. updated market range sheet
2. new time sheet, to show server offset hrs, market time.

Will put this excel into my simulator.

//
MT4 Market Data 2.02.xlsx

//
market1.png

//
time.png
This is great Thiru! Love the creativity! I would prolly recommend an EA to export indicator data to use in the sheet in an automated manner, then have excel connect to it as a data source, then set excel to refresh every 5 mins, or whichever timeframe suits your needs. I use a system similar to this in my workbook so I have two data sources, live and static, the static source pulls ATR data.

Check this out, you can also use excel to manage your trades, especially helpful if you have a large number of positions open and you want to manage them from a high level overview.

and the animation you see is quite cool too. :)
Capture.PNG

Re: Excel Live Trading Data

#27
thiru wrote:
Tue Jun 02, 2020 8:48 pm
Updated version 2.02

Change log;
1. updated market range sheet
2. new time sheet, to show server offset hrs, market time.

Will put this excel into my simulator.

//
MT4 Market Data 2.02.xlsx

//
market1.png

//
time.png
Update 2.03

Added a dashboard for simple navigation.
MT4 Market Data 2.03.xlsx
(93.94 KiB) Downloaded 282 times

Re: Excel Live Trading Data

#28
Lumios wrote:
Tue Jun 02, 2020 11:07 pm
This is great Thiru! Love the creativity! I would prolly recommend an EA to export indicator data to use in the sheet in an automated manner, then have excel connect to it as a data source, then set excel to refresh every 5 mins, or whichever timeframe suits your needs. I use a system similar to this in my workbook so I have two data sources, live and static, the static source pulls ATR data.
This is brilliant Lumios, I was wondering how to do this and you just gave the right hint. Now, I can now connect to a few exports and get live data every 1 min and some at every 4 hrs. This way, the ADR data is not longer statics !!!

time permitting, can you update the sheet with metals (gold and silver) and the indices? could never understand their pip values and margin requirements due to different contract sizes.

cheers

Re: Excel Live Trading Data

#30
thiru wrote:
Wed Jun 03, 2020 1:14 pm
Lumios wrote:
Tue Jun 02, 2020 11:07 pm
This is great Thiru! Love the creativity! I would prolly recommend an EA to export indicator data to use in the sheet in an automated manner, then have excel connect to it as a data source, then set excel to refresh every 5 mins, or whichever timeframe suits your needs. I use a system similar to this in my workbook so I have two data sources, live and static, the static source pulls ATR data.
This is brilliant Lumios, I was wondering how to do this and you just gave the right hint. Now, I can now connect to a few exports and get live data every 1 min and some at every 4 hrs. This way, the ADR data is not longer statics !!!

time permitting, can you update the sheet with metals (gold and silver) and the indices? could never understand their pip values and margin requirements due to different contract sizes.

cheers
man thiru i love it.................... the spreadsheet looking advance :In Love: :In Love: :In Love:
Contribution Inspector & GIF Animator at your service👮


Attachments 29
  1. Similar Topics

    1. 277 Replies
      50503 Views
    2. US Election Live Stream

      278 Replies 19136 Views

      by Jimmy, Wed Nov 04, 2020 12:23 am in Forex Fundamentals & News

      278 Replies
      19136 Views
    3. Data window only shows one value

      1 Replies 293 Views

      by ERP The Trader, Thu Dec 24, 2020 3:33 pm in MT4 Indicators

      1 Replies
      293 Views

Return to “MT4 Indicators”