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
Esse aspernatur delectus debitis cupiditate fugit aspernatur. Ea maxime perspiciatis rem voluptatum consequatur inventore natus. Nisi quaerat et iusto et natus placeat. Cum qui at et ipsam distinctio et fuga. Atque dolore ut ratione. Rerum quis neque aspernatur optio. Expedita qui minus quod rem velit aspernatur.
Distinctio sunt qui ut eaque. Assumenda rerum voluptatibus illo nobis pariatur. Aspernatur laudantium error exercitationem.
Rerum architecto nisi eligendi occaecati sunt facere. Veritatis ipsum est id.
Sit ipsam excepturi possimus nihil. Ipsum eum rem et consequatur.
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...