vf_GetHistory Function - Downloading Historical Price and Dividend Data into Excel
Loading...
Loading...
5:35
vf_GetDividend Function - Downloading Dividend Data into Excelby vbafin237 views- 2:09
Arhiv kotirovok - How to use the historical data?by fx1618com731 views
- 0:23
how to sort historical stock price dow jones index s&p 500 price excel etf yahoo microsoftby mech1500292 views
- 4:49
Downloading Option Chain into Excelby vbafin1,304 views
- 9:52
Bloomberg Excel Tutorialby stephenhillstz3,799 views
- 0:59
Downloading Stock Quotes from Yahoo directly to Excelby marcelosf33,364 views
- 14:06
Building your First Monte Carlo Simulation Model in Excelby FrontlineSolvers18,902 views
- 4:40
Finance in Excel 1 - Live Stock Quotes in Microsoft Excel - MSN MoneyCentral Investor Stock Quotesby ExcelisHell24,099 views
- 8:50
Import Yahoo Finance Prices with Perlby GameTreez280 views
- 3:02
Excel Trading Toolby vbafin3,297 views
- 9:47
Portfolio Optimizationby ModelRisk6,175 views
- 7:44
Finance in Excel 2 - Import and Chart Historical Stock Prices in Excelby ExcelisHell15,694 views
- 14:59
Use Excel to find buy and sell signals in the stock market!!by fosback132457,901 views
- 9:41
Import Controller Data Into Microsoft Excelby aquatracvids500 views
- 5:31
How to Embed stock market quotes into Excelby Scullyman998,256 views
- 4:25
RealtimeDataExpress :: How to Import Historical Databy RealtimeDataExpress2,815 views
- 4:13
How to transfer data from internet into Excelby jksynergyworks15,488 views
- 3:30
Options Chains in the Stock Marketby Hypermarketing539 views
- 2:07
Stock chart demoby nitin740141,248 views
- 3:32
yahoo!financeby smanzan13,518 views
The easiest (not necessary the best) way is to change the line
TempArray(r, 2) = Temp(1)
in Function ReadCsvFile, Module pxFunctions with the following:
If UBound(Temp) > 5 Then TempArray(r, 2) = Temp(6)
Else TempArray(r, 2) = Temp(1)
End If
I'll be making some changes to the add-in and update the site in the next few weeks that will incorporate a better solution for you.
vbafin 1 year ago
Does anyone know how to obtain close data rather than open data from the .csv file?? thanks
onedave1985 1 year ago