At the close of each trading day, I need the 50 and 200 period moving average values for multiple intraday time frames.
Thus, I’m using QLINK to assist me in getting this info.
However, it will not pull the necessary information into MS Excel when I use the formula below.
Need assistance with this formula;
=RTD("ESRTD",,"*H",<sym>,”PRD_Price200”,<i60>,<sta rt>,<index>)
Where
<sym> = NASDQ 100 (ex. AAPL, ADBE and etc.)
<fld> = Moving Average *200 Day
<agg> = intraday 60 minutes
<start> = blank
<index> = blank
Thus, I’m using QLINK to assist me in getting this info.
However, it will not pull the necessary information into MS Excel when I use the formula below.
Need assistance with this formula;
=RTD("ESRTD",,"*H",<sym>,”PRD_Price200”,<i60>,<sta rt>,<index>)
Where
<sym> = NASDQ 100 (ex. AAPL, ADBE and etc.)
<fld> = Moving Average *200 Day
<agg> = intraday 60 minutes
<start> = blank
<index> = blank
Comment