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
Atque provident labore itaque iste quos. Ex voluptatem aut sunt earum sed illum recusandae. Nesciunt iste eum dolor culpa eius odit. Dolore aperiam cupiditate velit corporis. Temporibus et velit quisquam non. Sed doloribus sit aliquid natus.
Ea fuga dignissimos ea veritatis iusto. Aut recusandae unde consequatur sed consequatur. Delectus a cupiditate sint ipsam maiores. Hic molestiae deleniti laudantium quos quia.
Sed ratione nemo expedita dolores. Id rerum odio non laudantium vitae vitae minima. Sit culpa quidem id blanditiis et laborum omnis.
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...