NexusFi: Find Your Edge


Home Menu

 





Help extracting weekly data - where is it hidden?


Discussion in Traders Hideout

Updated
      Top Posters
    1. looks_one aquarian1 with 3 posts (0 thanks)
    2. looks_two GoldenRatio with 3 posts (0 thanks)
    3. looks_3 Big Mike with 2 posts (0 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 3,189 views
    2. thumb_up 0 thanks given
    3. group 1 followers
    1. forum 8 posts
    2. attach_file 1 attachments




 
Search this Thread

Help extracting weekly data - where is it hidden?

  #1 (permalink)
 
GoldenRatio's Avatar
 GoldenRatio 
Philadelphia, PA
 
Experience: Advanced
Platform: Matlab, TradeStation
Trading: Stocks
Posts: 211 since Aug 2012
Thanks Given: 5,192
Thanks Received: 296

Hello everyone,

I am helping a friend who is interested in historical stock data charted at: http://research.investors.com/quotes/nasdaq-apple-inc-aapl.htm

The daily data is there (starting at line 1294) if you view the webpage source. However, if you select 'weekly' on the main webpage (chart changes to weekly data) and again select to view the source, only daily data is listed? Where is the weekly data hidden? It's not calculated via daily b/c the daily doesn't go back as far. Is the weekly data extractable? Thanks for your time and help.

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Trade idea based off three indicators.
Traders Hideout
What broker to use for trading palladium futures
Commodities
ZombieSqueeze
Platforms and Indicators
REcommedations for programming help
Sierra Chart
 
  #3 (permalink)
 
aquarian1's Avatar
 aquarian1 
Point Roberts, WA, USA
 
Experience: Advanced
Platform: IB and free NT
Broker: IB
Trading: ES
Posts: 4,034 since Dec 2010
Thanks Given: 1,509
Thanks Received: 2,593


you can get historical data from finance.yahoo.com

for apple
AAPL Historical Prices | Apple Inc. Stock - Yahoo! Finance

at bottom left of the page is says
download to spreadsheet.

..........
peace, love and joy to you
.........
Attached Files
Elite Membership required to download: apple weekly.csv
Visit my NexusFi Trade Journal Reply With Quote
  #4 (permalink)
 
GoldenRatio's Avatar
 GoldenRatio 
Philadelphia, PA
 
Experience: Advanced
Platform: Matlab, TradeStation
Trading: Stocks
Posts: 211 since Aug 2012
Thanks Given: 5,192
Thanks Received: 296

Thanks aquarian1,

They are aware of these other sources but want to use this source as the volume data is significantly different.

Any ideas how to extract the data that creates the weekly chart?

Started this thread Reply With Quote
  #5 (permalink)
 
aquarian1's Avatar
 aquarian1 
Point Roberts, WA, USA
 
Experience: Advanced
Platform: IB and free NT
Broker: IB
Trading: ES
Posts: 4,034 since Dec 2010
Thanks Given: 1,509
Thanks Received: 2,593

I looked at the page source (first) and could not see it there and I think it calls a prg to generate a PHP page.
Not sure but if this is the case I don't know how you would get it.

..........
peace, love and joy to you
.........
Visit my NexusFi Trade Journal Reply With Quote
  #6 (permalink)
 
aquarian1's Avatar
 aquarian1 
Point Roberts, WA, USA
 
Experience: Advanced
Platform: IB and free NT
Broker: IB
Trading: ES
Posts: 4,034 since Dec 2010
Thanks Given: 1,509
Thanks Received: 2,593

I noticed you said the volume data is different - would that mean you feel it is more correct or just better suited to your purposes?

NT export daily data using Kinetick (which I have heard is very good). So if you are looking for a check on accuracy you can export the dailty to a CSV and sum a few weeks to check to see which source in more in-line with Kinetick.

..........
peace, love and joy to you
.........
Visit my NexusFi Trade Journal Reply With Quote
  #7 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,465 since Jun 2009
Thanks Given: 33,242
Thanks Received: 101,665


GoldenRatio View Post
Hello everyone,

I am helping a friend who is interested in historical stock data charted at: Apple Inc Stock Quote: AAPL Stock News, Quotes, Analysis | Investors.com

The daily data is there (starting at line 1294) if you view the webpage source. However, if you select 'weekly' on the main webpage (chart changes to weekly data) and again select to view the source, only daily data is listed? Where is the weekly data hidden? It's not calculated via daily b/c the daily doesn't go back as far. Is the weekly data extractable? Thanks for your time and help.

Instead of reverse engineering a website for weekly data, much better to either use an actual data feed and an API (like IQFeed or etc) if you are a developer, or use a reliable public data source like Yahoo data.

If the weekly volume on this website is different than aggregated daily volume data, step 1 is to fully document and understand the correct method to build a weekly chart.

Mike



Join the free Markets Chat beta: one platform, all the trade rooms!

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #8 (permalink)
 
GoldenRatio's Avatar
 GoldenRatio 
Philadelphia, PA
 
Experience: Advanced
Platform: Matlab, TradeStation
Trading: Stocks
Posts: 211 since Aug 2012
Thanks Given: 5,192
Thanks Received: 296

Thanks for all the replies. I agree with all the suggestions (I would do them) but ... this is not my request - I am simply helping a friend.

For whatever reason they want the weekly volume data posted there. I concur the obvious solution is to create weekly data from the daily. That can easily be done. Their response was the weekly data goes back further and would take months to build a database to generate weekly charts as long. Anyway, I thought no harm in asking the smart minds here is they knew of a way 'seeing' weekly data from the site.

Appreciate everyone's time and input!

Started this thread Reply With Quote
  #9 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,465 since Jun 2009
Thanks Given: 33,242
Thanks Received: 101,665


GoldenRatio View Post
Thanks for all the replies. I agree with all the suggestions (I would do them) but ... this is not my request - I am simply helping a friend.

For whatever reason they want the weekly volume data posted there. I concur the obvious solution is to create weekly data from the daily. That can easily be done. Their response was the weekly data goes back further and would take months to build a database to generate weekly charts as long. Anyway, I thought no harm in asking the smart minds here is they knew of a way 'seeing' weekly data from the site.

Appreciate everyone's time and input!

Many sites like Yahoo, Google, Quandl, others have huge repositories of historical data for free for daily data, some of which would start at the conception of the instrument.

I would encourage this route over being tied to a particular 'hack'.

Mike



Join the free Markets Chat beta: one platform, all the trade rooms!

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote




Last Updated on July 1, 2014


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts