New answers tagged excel
-1
votes
Loading HF stock data into excel
In case you are interested in out-of-the-box solutions, I am using this to get intra-day price in Excel, very convenient.
1
vote
Automatically Import Stock Data - Yahoo Finance & Microsoft Excel
If you know about Microsoft Power BI, you can use it and pick which columns of which tables you want to import.
add tables using examples button at the bottom as in the attached images.
Then start to ...
1
vote
Automatically Import Stock Data - Yahoo Finance & Microsoft Excel
There is no direct connection for excel.
These steps work though.
Still tedious but Yahoo Finance is what it is. You can use https://finance.yahoo.com/quote/GOOG/analysis?p=GOOG and combine this with ...
2
votes
Accepted
Alpha calculation inconsistent across methodologies
I think there are a couple points to make here:
The frequency of the returns here is important. Because you fitted your model using monthly returns, the model is going to be modelling monthly returns ...
Top 50 recent answers are included
Related Tags
excel × 96bloomberg × 26
programming × 15
vba × 10
quantlib × 9
volatility × 6
equities × 6
fixed-income × 6
finance × 5
monte-carlo × 5
backtesting × 5
interest-rates × 4
bond × 4
data × 4
returns × 4
portfolio-management × 3
factor-models × 3
interest-rate-swap × 3
modeling × 3
forecasting × 3
bond-yields × 3
swaption × 3
standard-deviation × 3
options × 2
option-pricing × 2