Need help with VBA code making High/Low values

F

fagot

New Member
#1
#1
Hello.
I have real-time coming Last values (current price values of any stock) for example in "B2" Excel cell. How to make in "C2" Excel cell High, in "D2" cell Low real-time values for 1 min timeframe.
Result - 4 Excel Columns with real-time data: Symbol, Last, High, Low.
 
R

rvaghani

New Member
#2
#2
How you are getting data to excel sheet? which service you have?
you can use code like this
Function xmax2(d1 As Double, d2 As Double)
x12 = IIf(d1 > d2, d1, d2)
Worksheets("Sheet1").Range("C1") = x12
End Function
 
F

fagot

New Member
#3
#3
Rvaghani. Thank you for reply.
I am going to use LaserTrade (genesis). But now I export data from Thinkorswim (demo with 20 min delay) - US stocks.
I am newbie in VBA (started to read books only), Can you make Excel File with working example. I think testing can be done by changing values in "B2" cell.
Fagot.

rvaghani said:
How you are getting data to excel sheet? which service you have?
you can use code like this
Function xmax2(d1 As Double, d2 As Double)
x12 = IIf(d1 > d2, d1, d2)
Worksheets("Sheet1").Range("C1") = x12
End Function
Click to expand...
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
N need help get open positions of day before AmiBroker 0
G Need Help with converting this Pinescript to AFL AmiBroker 0
A Help - Need GOLDM24JANFUT Data From 1 to 5 Jan 2024 Data Feeds 1
J Backtesting with 1min IEOD data in amibroker, help needed Algo & Automated Trading 1
M Pls Help...Need Upper and Lower Bollinger Band {20,1) breakout and Mid Bollinger Band (20,1) Break out exploration AFL Technical Analysis 0

Similar threads