Excel Forum

EXCEL MANAGER

Goran Zoric

Active Member

Members

Forum Posts: 3

Member Since:
October 22, 2022

Offline

October 22, 2022 - 8:04 pm

Pozdrav!

Treba mi formula koja će automatski pokrenuti trgovinu u Mt4, ali na osnovu VRIJEDNOSTI ćelije. primjer:
Ćelija je dostigla vrijednost od 75% = Trgovina je otvorena u Mt4.
Ćelija dostigla 65% vrijednosti = Trgovina zatvorena u Mt4
Osnovna formula bi izgledala ovako: strResult = cmd.SendCommand("123789", "BUY", "s=EURUSD|v=10000", 5)
ali u formuli gdje piše -kupi-, treba mi omjer ćelija (gogili12+xlsx) (I31 i J31), recimo: if : I31> of J31=BUY ili if : J31>of I31 = SELL. TAKO ĆE EXCEL ZNATI DA LI DA POČNE TRGOVATI KUPOVINOM ILI PRODAJOM. i posljednja stavka u formuli: v=1000", 5) za koju ja razumijem da predstavlja vrijednost ćelije bi trebala reagirati na vrijednost koju sam naveo, na primjer: ako je vrijednost > od 75% = DA (započnite trgovinu) a ako je vrijednost u istoj ćeliji pala na 68% = NE (zaustavi trgovinu).Sve ovo treba da se desi u jednoj ćeliji (K31) fajl (gogili12+xlsx).U K31 formula određuje da li će se trgovina započeti i da li ce biti kupovina ili prodaja na osnovu vrednosti celija (I31 i J31).Kako napisati formulu u ćeliju K31?Kada otvoriš (gogili12+xlsx) biće ti jasno.u FIVER-u.

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1845

Member Since:
November 8, 2013

Offline

October 25, 2022 - 2:34 pm

Hi Goran,

Welcome to our forum.

Please use google translate to understand each other easily.

Greetings!

I need a formula that will automatically start a trade in Mt4, but based on cell RANDOM. example:
Cell has reached a value of 75% = Trade is open at Mt4.
Ćelija reached 65% of value = Trade closed at Mt4
The basic formula would look like this: strResult = cmd.SendCommand("123789", "BUY", "s=EURUSD|v=10000", 5)
but in the formula where it says -buy-, I need the cell ratio (gogili12+xlsx) (I31 and J31), let's say: if : I31> of J31=BUY or if : J31>of I31 = SELL. SO EXCEL KNOWS WHETHER TO START TRADING BY BUYING OR SELLING. and the last sentence in the formula: v=1000", 5) which I understand to represent the value of the cell should react to the value I specified, for example: how is the value > from 75% = DA (start the trade) and how is the value in the same cell, it burned to 68% = NO (stop the trade). All this must be done in one cell (K31) file (gogili12+xlsx). In K31, the formula determines whether the trade will start and whether it will be bought or sale based on the value of the cell (I31 and J31). How to write the formula for cell K31? When you open (gogili12+xlsx) it will be clear to you. at FIVER.