Technical Analysis - Price Transforms
- Average Price (AVGPRICE)
- Median Price (MEDPRICE)
- Typical Price (TYPPRICE)
- Weighted Close Price (WCLPRICE)
Related insights
Importing data into Excel
Excel allows to add data from different sources. We offer our Alphacast Excel Add-In to simplify the process of downloading data. However, some customers may not have the chance to install an Add-In. Here you can find an alternative way to embed data into Excel, by using our TSV data source:
Getting TSV download
¿Cómo unir el contenido de dos datasets?
Seguramente en tu trabajo habitual con datos necesitaste cruzar varias fuentes de datos y si tu herramienta de cálculo es Excel posiblemente lo resuelvas con alguna combinación de las formulas VLOOKUP, HLOOKUP y/o MATCH. Excel es una gran solución en muchos casos, pero suele traer dificultades en algunos escenarios. Por ejemplo, cuando...
Alphacast's Integrations: Interacting with the API on R
- Integrating Alphacast with R (YOU ARE HERE)
- Integrating Alphacast with Python
- How to install the Excel add-in
Technical Analysis - Statistics Functions
- Beta (BETA)
- Pearson's Correlation Coefficient (r) (CORREL)
- Linear Regression (LINEARREG)
- Linear Regression Angle (LINEARREG_ANGLE)
- Linear Regression Intercept (LINEARREG_INTERCEPT)
- Linear Regression Slope (LINEARREG_SLOPE)
- Standard Deviation (STDDEV)
- Time Series Forecast (TSF)
- Variance (VAR)
