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!