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


Re: Excel Live Trading Data

#32
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
its possible to pull that data if your broker provides it. My broker is OANDA and therefore dont have access to commodities or indices. If you look at the formulas for commodities, just edit the symbol in the formula and that should work. Will look into the PIP values.

Will work on a mockup for trade tracking soon. Essentially the formula works like this:
(open price) --- (Current Price) --- (TP price). Your finding the % of the current price to the target price. So...formula...
((current price)-(open price))/((TP price)-(current price))

Cheers!

Re: Excel Live Trading Data

#33
Lumios wrote:
Thu Jun 04, 2020 8:17 am
its possible to pull that data if your broker provides it. My broker is OANDA and therefore dont have access to commodities or indices. If you look at the formulas for commodities, just edit the symbol in the formula and that should work. Will look into the PIP values.

Will work on a mockup for trade tracking soon. Essentially the formula works like this:
(open price) --- (Current Price) --- (TP price). Your finding the % of the current price to the target price. So...formula...
((current price)-(open price))/((TP price)-(current price))

Cheers!
man................. im still so mind blown from this hehe.................. love this excel trading spreadsheets
Contribution Inspector & GIF Animator at your service👮


Re: Excel Live Trading Data

#36
aabtc wrote:
Sun Jun 07, 2020 9:52 pm
Can these two functions be added,Positive currency correlation ,Currency negative correlation,xau/usd
To add new symbols, add a new row and edit the formulas per how your broker codes them. To see the formula, highlight the box and look in the formula bar. Ill put together a screenshot tutorial on how to add new symbols in a day or so.

Re: Excel Live Trading Data

#37
great job. thanks for this important piece.

can anyone assist me with the installation process of Mac. I dont seem to find the option for setting DDE . Thanks

Re: Excel Live Trading Data

#38
package wrote:
Mon Sep 21, 2020 4:34 am
great job. thanks for this important piece.

can anyone assist me with the installation process of Mac. I dont seem to find the option for setting DDE . Thanks
Sorry, not possible on Mac
credits


Of course, you could run a virtual machine hosting Windows and it should work ;)


Attachments 29
  1. Similar Topics

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

      275 Replies 18039 Views

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

      275 Replies
      18039 Views
    3. Daily Data

      1 Replies 966 Views

      by jisun09, Sat Jul 11, 2020 12:57 am in MT4 Indicators

      1 Replies
      966 Views

Return to “MT4 Indicators”