Macro second a parte.
Sub Aggiorna_Tabella()
Riga_tab = Riga_tab + 1
Worksheets("VWAP").Cells(Riga_tab, 2).Value = VWAP
Worksheets("VWAP").Cells(Riga_tab, 4).Value = PrezzoFUT
Worksheets("VWAP").Cells(Riga_tab, 6).Value = deltaFUT
Worksheets("VWAP").Cells(Riga_tab, 8).Value = PVP
Worksheets("VWAP").Cells(Riga_tab, 10).Value = VWAP + Worksheets("VWAP").Cells(1, 1).Value 'errore all'inizio
Worksheets("VWAP").Cells(Riga_tab, 12).Value = VWAP + Worksheets("VWAP").Cells(1, 1).Value * 2 'errore all'inizio
End Sub
Sub Aggiorna_PVP()
Dim Max As Long
Dim Valore As Long
Cella_pvp = Worksheets("VWAP").Range("M1").Value
Cella_vwap = Worksheets("VWAP").Range("N1").Value
For I = 1 To 400
If Worksheets("PVP").Cells(I, 1).Value = PrezzoFUT Then
Worksheets("PVP").Cells(I, 2).Value = Worksheets("PVP").Cells(I, 2).Value + 1
I = 399
End If
Next I
'Determina PVP
Max = 0
Worksheets("PVP").Cells(Cella_pvp, 3).Value = ""
Worksheets("PVP").Cells(Cella_vwap, 4).Value = ""
For I = 1 To 400
If Worksheets("PVP").Cells(I, 2).Value >= Max Then
PVP = Worksheets("PVP").Cells(I, 1).Value
Cella_pvp = I
Worksheets("VWAP").Range("M1").Value = Cella_pvp
Max = Worksheets("PVP").Cells(I, 2).Value
End If
Valore = VWAP / 10
Valore = Round(Valore) * 10
Worksheets("PVP").Cells(230, 4).Value = Valore
If Worksheets("PVP").Cells(I, 1).Value = Valore Then
Cella_vwap = I
Worksheets("VWAP").Range("N1").Value = Cella_vwap
Worksheets("PVP").Cells(Cella_vwap, 4).Value = Max
End If
Next I
Worksheets("PVP").Cells(Cella_pvp, 3).Value = Max
Worksheets("Fut").Range("O12").Value = PVP
End Sub
Sub Inizializza()
Dim Chiusura As Long
Worksheets("PVP").Range("A1400").Value = ""
Worksheets("VWAP").Range("A2:L8000").Value = ""
Worksheets("Fut").Range("A40:E50").Value = ""
Worksheets("Fut").Range("F40:H40").Value = ""
Worksheets("Fut").Range("O11:O12").Value = ""
Chiusura = Round(Worksheets("Fut").Range("O9").Value / 5, 0)
Chiusura = Chiusura * 5
For I = 0 To 399
Worksheets("PVP").Cells(I + 1, 1).Value = Chiusura + ((I - 200) * 5)
Next I
Cella_pvp = 1
Cella_vwap = 1
Riga_tab = 1
Worksheets("VWAP").Range("M1").Value = Cella_pvp
Worksheets("VWAP").Range("N1").Value = Cella_vwap
Worksheets("VWAP").Range("B2:B3").Value = 1
End Sub
Sub Aggiorna_Tabella_ISP()
' vuota
End Sub
Sub Aggiorna_Tabella()
Riga_tab = Riga_tab + 1
Worksheets("VWAP").Cells(Riga_tab, 2).Value = VWAP
Worksheets("VWAP").Cells(Riga_tab, 4).Value = PrezzoFUT
Worksheets("VWAP").Cells(Riga_tab, 6).Value = deltaFUT
Worksheets("VWAP").Cells(Riga_tab, 8).Value = PVP
Worksheets("VWAP").Cells(Riga_tab, 10).Value = VWAP + Worksheets("VWAP").Cells(1, 1).Value 'errore all'inizio
Worksheets("VWAP").Cells(Riga_tab, 12).Value = VWAP + Worksheets("VWAP").Cells(1, 1).Value * 2 'errore all'inizio
End Sub
Sub Aggiorna_PVP()
Dim Max As Long
Dim Valore As Long
Cella_pvp = Worksheets("VWAP").Range("M1").Value
Cella_vwap = Worksheets("VWAP").Range("N1").Value
For I = 1 To 400
If Worksheets("PVP").Cells(I, 1).Value = PrezzoFUT Then
Worksheets("PVP").Cells(I, 2).Value = Worksheets("PVP").Cells(I, 2).Value + 1
I = 399
End If
Next I
'Determina PVP
Max = 0
Worksheets("PVP").Cells(Cella_pvp, 3).Value = ""
Worksheets("PVP").Cells(Cella_vwap, 4).Value = ""
For I = 1 To 400
If Worksheets("PVP").Cells(I, 2).Value >= Max Then
PVP = Worksheets("PVP").Cells(I, 1).Value
Cella_pvp = I
Worksheets("VWAP").Range("M1").Value = Cella_pvp
Max = Worksheets("PVP").Cells(I, 2).Value
End If
Valore = VWAP / 10
Valore = Round(Valore) * 10
Worksheets("PVP").Cells(230, 4).Value = Valore
If Worksheets("PVP").Cells(I, 1).Value = Valore Then
Cella_vwap = I
Worksheets("VWAP").Range("N1").Value = Cella_vwap
Worksheets("PVP").Cells(Cella_vwap, 4).Value = Max
End If
Next I
Worksheets("PVP").Cells(Cella_pvp, 3).Value = Max
Worksheets("Fut").Range("O12").Value = PVP
End Sub
Sub Inizializza()
Dim Chiusura As Long
Worksheets("PVP").Range("A1400").Value = ""
Worksheets("VWAP").Range("A2:L8000").Value = ""
Worksheets("Fut").Range("A40:E50").Value = ""
Worksheets("Fut").Range("F40:H40").Value = ""
Worksheets("Fut").Range("O11:O12").Value = ""
Chiusura = Round(Worksheets("Fut").Range("O9").Value / 5, 0)
Chiusura = Chiusura * 5
For I = 0 To 399
Worksheets("PVP").Cells(I + 1, 1).Value = Chiusura + ((I - 200) * 5)
Next I
Cella_pvp = 1
Cella_vwap = 1
Riga_tab = 1
Worksheets("VWAP").Range("M1").Value = Cella_pvp
Worksheets("VWAP").Range("N1").Value = Cella_vwap
Worksheets("VWAP").Range("B2:B3").Value = 1
End Sub
Sub Aggiorna_Tabella_ISP()
' vuota
End Sub