DislikedDoes any know how to record with a dynamic timestamp in Excel? A VBA code perhaps that can help? I want to record the time when certain conditions are met in a column. I can assign a cell in Excel that will represent the conditions but do not know how to record a dynamic time stamp in a column. The timestamped cell should not be refreshed but rather a new cell will contain the new timestamp when the same conditions are met again.Ignored
MT4 to Excel through Excel RTD (Finally!)
{quote} Let's say you have the time of mt4 (='MT4'|TIME!GBPAUD) running in A1 and the conditions are met in your other cell, then you just use "copy" in vba from e.g. A1 to B1. Sheets("Your_Sheet").Range("A1").Copy Sheets("Your_sheet").Range("B1").PasteSpecial Paste:=xlPasteValues Best of luck and stay green always!Jibala
{quote} Let's say you have the time of mt4 (='MT4'|TIME!GBPAUD) running in A1 and the conditions are met in your other cell, then you just use "copy" in vba from e.g. A1 to B1. Sheets("Your_Sheet").Range("A1").Copy Sheets("Your_sheet").Range("B1").PasteSpecial Paste:=xlPasteValues Best of luck and stay green always!
I am searching now to find a solution for it.
{quote} I guess what you want to know looks like that: {image} If once you're familiar with all that syntax stuff you can do lots of calculations. Together with little developer skills, you are able to develop amazing trading tools. My current favourite is the GER30 Scalper & Swing Trader. {image}{image} Best of luck and stay green always!
hi sir, how can u do this ？
- #54
- Oct 15, 2020 2:09pm Oct 15, 2020 2:09pm
- Joined Jun 2014 | Status: Trader | 2,498 Posts
{quote} The two keywords for learning how to do this is Linking Shapes to Data in Excel. An example is shown here https://www.youtube.com/watch?v=bWiE6qVNAoU NB: I am not sure if I am allowed to insert youtube links in FF? If not I will delete it and the principle is the same. Search for Shapes and Data in Excel.
Best of luck and stay green always!
Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
{quote} The so-called pro traders in the prop trading firms will always say one thing...technical analysis doesn't work. Let's prove them wrong.
Hi antariks,
Can you share the sample sheet that has the VBA code? I mean the one that has the clickable button. I could not find mine and it will take me a while.
I have read the PDF pages with regard to the sending of commands. They are not formulas to be written in a cell. They are rather a VBA. I do not know much about VBA but hopefully, I can make a few changes to the original sample sheet. I tried to create one in the "Developer" but it gave me back an error.
My hope is that if I see the original VB, I may be able to follow up and understand more the PDF instructions or at least perform what you need (i.e initiate the trade automatically without clicking on the button".
BTW, the PDF does mention how to create a clickable button but I could not implement it. I might have been missing a few commands.
- #57
- Oct 21, 2020 1:35pm Oct 21, 2020 1:35pm
- Joined Jun 2014 | Status: Trader | 2,498 Posts
{quote} Can you share the sample sheet that has the VBA code? I mean the one that has the clickable button.
Inserted Code
Private Sub CommandButton1_Click()
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
strResult = cmd.SendCommand(RTD!A1, "BUY", "s=EURUSD|v=1500", 5)
End Sub
Private Sub CommandButton2_Click()
Set cmd = CreateObject("FXBlueLabs.ExcelCommand")
strResult = cmd.SendCommand(RTD!A1, "SELL", "s=EURUSD|v=1500", 5)
End Sub Best of luck and stay green always!
Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
{quote} Just add an ActiveX Controls CommandButton and add the VBA Macro to it. {image} {image} Private Sub CommandButton1_Click() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand(RTD!A1, "BUY", "s=EURUSD|v=1500", 5) End Sub Private Sub CommandButton2_Click() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand(RTD!A1, "SELL", "s=EURUSD|v=1500", 5) End Sub Best of luck and stay green always!
Thanks Jibala for your guidance. I will work on it tonight.
{quote} Just add an ActiveX Controls CommandButton and add the VBA Macro to it. {image} {image} Private Sub CommandButton1_Click() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand(RTD!A1, "BUY", "s=EURUSD|v=1500", 5) End Sub Private Sub CommandButton2_Click() Set cmd = CreateObject("FXBlueLabs.ExcelCommand") strResult = cmd.SendCommand(RTD!A1, "SELL", "s=EURUSD|v=1500", 5) End Sub Best of luck and stay green always!
A question....instead of putting a constant volume there, I will try to put a cell reference number and see what happenes.
Can we make it more conditional? For ex, as in Excel, =IF(AND(R520>0, S520<0, S527=1),"Buy","Sell")