Excel and VBA analysis

Quoting JR97

Disliked

Hey Tom, looks like you're using a lot of recorded macro vba. Just be aware that recorded vba can fail since active cell/sheet/etc is relative to whatever is active at the time of recording unless you specifically choose a certain active cell. It's better to use the Excel workbook/worksheet/range object model and explicitly assign things to variables and range objects. It's a more accurate and scalable approach. I've been putting together some code for working with MT4 output I'll post up if you're interested. Do you have any development experience...

Ignored

Sub OpenCSV()
    Dim sourceWb As Workbook
    Dim targetWb As Workbook
    Dim sourceWs As Worksheet
    Dim targetWs As Worksheet
    Dim sourceRng As Range
    Dim targetRng As Range
    Dim fPath As String
    Dim fName As String
    Dim lastCell As Integer
        
    'Set target workbook, worksheet, and range.
    Set targetWb = ActiveWorkbook
    Set targetWs = targetWb.Worksheets("Mt4")
    
    'Set file path and file name
    fPath = "C:\MetaQuotes\MQL4\Files\"
    fName = "[email protected]"
    
    'set sourceWb object to file to open
    Set sourceWb = Workbooks.Open(fPath & fName, False, True)
    
    'set the source range to the contiguous area from A1 and find the last row number
    Set sourceRng = sourceWb.Worksheets(1).Range("A1").CurrentRegion
    'sourceRng.Copy
    lastCell = sourceRng.Rows.Count
    Debug.Print lastCell
        
    'Clear existing data
    targetWs.Range("A1").CurrentRegion.Clear
    
    'Header Row
    targetWs.Range("A1") = "DATE"
    targetWs.Range("B1") = "TIME"
    targetWs.Range("C1") = "OPEN"
    targetWs.Range("D1") = "HIGH"
    targetWs.Range("E1") = "LOW"
    targetWs.Range("F1") = "CLOSE"
    targetWs.Range("G1") = "VOLUME"
    targetWs.Range("H1") = fName
    'set the target range values to the source range values then close the .csv file
    targetWs.Range("A2:G" & lastCell + 1).Value = sourceRng.Value
    sourceWb.Close False
End Sub

Quoting dingdong99

Disliked

Hello, Mr. Tom, and Mr. JR97 ..... if it is possible to export data time frame, and a pair .... ?? like EURUSD export data at time frame M5, M15, until W1 ....?

Ignored

Quoting SamHo2013

Disliked

Thanks for Tom_D_Trader and JR97. What would the code look like if I just need to extract the today's OHLC from MT4 without opening or even creating the csv file? (modulator please tell me why if you block my message to publish, you have been always blocking my messages without reason)

Ignored

Quoting tigretoncio

Disliked

And is there a way to export data from indicators associated to a chart (MAs,Stochs,...) to csv? Thanks

Ignored

Quoting Tom_D_Trader

Disliked

Here is an easy MM excel sheet for managing EU and UJ trades. It is just one way but you can adapt it if you wish. If you find some bug please report. Numbers are ofc fake, apart from those entries. {file}

Ignored

Quoting tigretoncio

Disliked

And is there a way to export data from indicators associated to a chart (MAs,Stochs,...) to csv? Thanks

Ignored

Quoting JR97

Disliked

sorry I didn't get back to you sooner.

Ignored

Quoting JR97

Disliked

This offer isn't on the table forever, so take advantage while it is.

Ignored