faster, better daily market updates using Excel VBA (code included)
I wanted to share a tool I use to stay up to date with the markets with all the other monkeys out there looking for a job especially in S&T. I use a pretty cool excel sheet to get my daily market updates without having to surf through the web/click back and forth between different websites. Its such a hassle and I cannot analyze the data the way I want but with this sheet its easy. I made one to grab historical data and create graphs. I'm also trying to make one to grab options chains. If anyone knows how to do that feel free to pm me I would appreciate any insight.
Edit: WSO is not supporting my .xml file so I have made a .xls version. To make it work open the VB editor in the excel sheet, create a new module, and paste the code from the word doc.
Edit: yes I did base my code in the first "daily updates" sheet off a sheet i found online I am not trying to rip it off I also make my own as i have evidence with the historical data grab.
| Attachment | Size |
|---|---|
| wsohistoricalanddaily.doc 30.5 KB | 30.5 KB |
| wsodailymarketdatastartaug28.xls 566.5 KB | 566.5 KB |
| wsoticker_history.xls 401 KB | 401 KB |
WSO isnt supporting the macro i'll try to fix it :(
http://www.marketindex.com.au/yahoo-finance-api#part2
Your sheet looks similar to the sample sheet listed here...
The macros are identical...
vbamonkey you might want to not pawn off public sheets as yours by changing the formatting to get a job
Harambe didn't die for coding plagiarism
You bet your ass he didn't. Harambe looked down upon cheaters and thieves.....just as he now look down upon all of us from behind the pearly gates of heaven.
He also lists his full name and email in the sheet. Lying gets you dinged.
You are right i should not list my name in anything posted on WSO anyways I appreciate your point. Was not trying to rip off other work was just trying to share. not gonna lie also trying to grab someones attention but clearly that was a mistake
Et hic qui excepturi iusto. Aut qui provident incidunt numquam repellendus. Et ratione assumenda exercitationem accusamus ratione fuga. Earum nesciunt voluptatum eum officia.
Ratione officiis consequatur non quibusdam. Ad sit voluptate qui doloremque odit.
Unde at consequatur odit dicta in rerum. Iusto quia consequatur est. Fugiat numquam et similique omnis eius. Eius magnam officia quia ut dolore sunt recusandae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...