We use technologies like cookies to store and/or access device information. We do this to improve browsing experience and to show (non-) personalized ads. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Do you have a spreadsheet for American Options that includes Skew / Kurtosis parameters?
Cheers
James
Hello
I am interested in downloading stock information from Yahoo in a excel format using MsAccess as the source of Stock Codes and the Stock Costs
Could you please advise me if this information is available from your company?
Thank you
Paul Finch
Hi Samir,
can you write for me formula that gets data from yahoo finance, like open, close, dividends, adjusted price etc.
e.g. I have a tickers in one colum, date in another column like:
MA 10/15/2014
AXP 10/16/2014
the formula should take ticker from one column and dates from another and place required data in next columns like:
MA 10/15/2014 24.15 24.20 24.45
AXP 10/16/2014 54.31 54.78 54.95
Why would I do that for you?
Hi Samir,
I can’t seem to locate your tutorial. Can you help direct me?
Thanx,
Sal
What tutorial?
I wanted to integrate your Live stock quote VBA into the Tading Journal Spreadsheet so I can keep the “last trade” accurate without manual input.
The Trading Journal is locked in the VBA editor and you mention to unlock it by buying the spreadsheet. I can only see the options sheets listed here for purchase and not the basic trading journal.
Hi Pricing Expert,
May I urgently seek for your help below:
1. Can you write a MC simulation for stock price simulation with a series of discrete dividend payments with non-constant volatility using Local Volatility Model?
2. In building Local Volatility Model, would you pls incorporate a series of discrete dividend payments with actual examples with call/put implied Vol Surface from Bloomberg / Reuters and build Local Volatility Modeling from Implied Vol Surface?
Thanks!
Clement
Hello Samir
I saw you awesome intraday excel file.
I would like buy an excel spreadsheet witch produces the following customized intraday data output:
CLOSE, HIGH, LOW, OPEN, VOLUME, DATE, TIME
(The DATE and TIME should be separated into different cells) and the data must be saved to csv file.
If possible, can the data be refreshed/loop every minute.
Thank you.
I had a spreadsheet I used to analyze dividend stocks. It used VBA functions that accessed the Yahoo historical stock data which no longer works as of May 2017. I am working to make my spreadsheet work again. I see that we can get historical closing prices for many stocks from Google Finance. Where can I download historical dividend data from?