moey_dw wrote: Wed Jun 03, 2020 9:26 pm
man thiru i love it.................... the spreadsheet looking advance

glad you like it ... hope we can keep improving this

thiru wrote: Wed Jun 03, 2020 1:14 pm

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!

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

Can these two functions be added，Positive currency correlation ，Currency negative correlation，xau/usd

Version 2.04

Added trade tracker.
---
--- ---

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.

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

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

Please i keep getting this ERROR message when i try to open the file

Thanks for sharing, so do you have file for google sheet ?