Tag Archives: Yahoo

Demo to download Yahoo Finance data in Python

Demo to download Yahoo Finance data in Python

A video demo with a proper set of code to download specific Yahoo Finance data

NOTE: Ensure to copy these codes into your own private document you can refer since Yahoo make take this down

http://www.myhow2.net/wp/2013/07/python-how-to-look-up-stock-price-using-yahoo-stock-data-service/

A copy of this is available for my Quant Elite Members

Join my FREE newsletter to learn more about using Yahoo Finance for algo trading

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Python packages for Yahoo Finance and World Bank

Python packages for Yahoo Finance and World Bank

I plan to use a few of these for my upcoming trading system

http://quant-econ.net/py/pandas.html

http://www.thealgoengineer.com/2014/download_sp500_data/

https://pypi.python.org/pypi/yahoo-finance   <– this will return market cap

http://stackoverflow.com/questions/28351139/why-is-my-beta-different-from-yahoo-finance <– example to calculate Beta

https://code.google.com/p/ultra-finance/ <– framework but has EPS

http://www.myhow2.net/wp/2013/07/python-how-to-look-up-stock-price-using-yahoo-stock-data-service/ <– this is like Gummy that was banned by Yahoo in Jan 2015 ref: http://www.gummy-stuff.org/Yahoo-data.htm

Join my FREE newsletter to see how I build out this algo trading system in Python

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

IQFeed symbols compared to Yahoo Finance

IQFeed symbols compared to Yahoo Finance

My Questions for IQFeed

  1. Do you have some online resource for a cross reference of list

symbols got IQFeed?

  1. What do you think the percentage of IQFeed symbols will be exact to

to Yahoo Finance? I am looking at specifically for US and Europe equity

exchanges

 

They responded with:

I think what you are looking for is our symbol database which is available for download and updated daily on our symbol lookup page towards the top. It has exchange symbols in there as well I believe. We should match US stocks with yahoo as long as they aren’t using exchange identifiers/suffix’s.  We don’t carry any European stocks.

Join my FREE newsletter to learn more about how IQFeed can change your automated trading 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Demo of Highcharts with Yahoo Finance

Demo of Highcharts with Yahoo Finance

This is all done in Javascript and C# so I am not that desperate to try

http://www.codeproject.com/Articles/1069489/Highstock-plus-Data-Forge-plus-Yahoo

Join my FREE newsletter to see if this charting library is useful for my automated trading 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Insert Yahoo FInance forex with Bitcoin data into PostGreSQL Database

Insert Yahoo FInance forex with Bitcoin data into PostGreSQL Database

Cardstock version for forex pairs

Details here with video

This a minor change to focus on pure forex data acquired for the expensive price of free

All source code provided to all my Quant Elite members 

Join my FREE newsletter to learn more where this utility goes 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Demo to stream Excel XLQ forex data into Matlab via FREE Yahoo Finance

Demo to stream Excel XLQ forex data into Matlab via FREE Yahoo Finance

This is pretty awesome and very very flexible but powerful for lazy people like me

Instructions :
Record your Excel macro
https://support.office.com/en-sg/article/Create-or-delete-a-macro-f3eb0fa3-4c18-498a-9235-c66ba8e78149

Start MATLAB from within the Excel Add in (see next link but can be automated)

http://www.mathworks.com/help/exlink/add-in-setup.html#bsu1116-1

Work with the Microsoft Visual Basic Editor
To enable Spreadsheet Link EX as a Reference in the Microsoft Visual Basic® Editor:
1. Open a Visual Basic session.
• If you are running Excel 2003, select Tools > Macro > Visual Basic Editor.
• If you are running Excel 2007 and later, click the Visual Basic button on the Developer tab, or press Alt+F11.
Note: For instructions about displaying the Developer tab, see Excel Help.
2. In the Visual Basic toolbar, select Tools > References.
3. In the References — VBA Project dialog box, select the SpreadsheetLinkEX or SpreadsheetLink2007_2010 check box.
4. Click OK.

VBA Code under Developer-Edit macro with automated scheduling every x seconds with refresh!:

Sub FXUpdateMatlab()
'
' FXUpdateMatlab Macro
' This runs FX check on list to populate into MATLAB

‘run every x seconds with refresh ozgrid.com/forum/showthread.php?t=77908
Application.OnTime Now + TimeValue(“00:00:10”), “FXUpdateMatlab”

ActiveWindow.ScrollWorkbookTabs Sheets:=1
ActiveWindow.ScrollWorkbookTabs Sheets:=1
Sheets(“Currency”).Select
Range(“A6:C13”).Select
MLPutMatrix “a”, Range(“A6:C13”) ‘http://www.mathworks.com/help/exlink/work-with-matlab-functions-in-microsoft-excel.html#bq8llit-1

ActiveWorkbook.RefreshAll

End Sub

Schedule the Macro to automatically run every x seconds or minutes via
http://www.ozgrid.com/forum/showthread.php?t=182559
http://stackoverflow.com/questions/24129613/using-excel-vba-macro-to-be-run-through-windows-schedule-task

Join my FREE if you are interested in learning other tricks with Matlab and Excel

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!