Update Excel VBA

Profile

Update Excel VBA
Apply API NASDAG
TASK 1 Charts
Replace charts under c column P with New Charts
Link charts to real time prices.
TASK 2 Vector
Download 52 weeks of real-time historical prices
Calculate the function F = 100 x ( P - P low) / ( P high - P low)
where P are historical prices;
P low and P max are prices from columns D and E of the main sheet
if F= 0 then P min
jf F = 100 then P max
Fill in the Vector column with logical characters: MORE. LESS, MAX, MIN, UP, DOWN FOR EACH SYMBOL.
IF P current = P max then VECTOR = MAX
IF P current > P max then VECTOR = MORE
IF P current = P min then VECTOR = MIN
IF P current
IF the date of P max BEFORE the date of P min then VECTOR= UP
IF the date of P min BEFORE the date of P max then VECTOR= DW
Save the indicator and delete the historical dada.
Test:
IIF Levels =
IF Levels => 100 then Vector = Max.
Skills:
Excel
, Visual Basic
, Visual Basic for Apps
, Software Architecture
, Excel VBA

Company info

Sign Up Now - WashingtondcCrossing.com