|
PureBytes Links
Trading Reference Links
|
Most of the "fundamental" stock and commodity data and other non-price data
is available on PDF files from the internet sites. You can open all or any
part of the PDF file directly into XL.
Attached is part of several wheat PDF files that I open daily. Use VBA
routines to sort to proper worksheet, exactly as you would for stock and
commodity price data. Cumulative or daily specialized trading volume can be
charted with your price chart in Metastock if you follow a specific funds
trading activity.
Open the PDF file with Acrobat or Acrobat Reader
Press the "Text Select Tool" button on the toolbar
Highlight your data
Edit --> Copy
Open XL
Edit -->Paste
(your data will all be squished together)
Data --> Text to Columns
select delimiter that puts your data into columns
Best regards
Walter
Attachment Converted: "f:\eudora\attach\Open PDF file into XL.gif"
|