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
Nam dolorem sit repudiandae magni. Consequuntur dolores at est nihil debitis amet occaecati cum. Ea sed similique maiores ut non. Veniam non ea aperiam dolores praesentium. Sunt aut necessitatibus quia quae deleniti. Praesentium dolorem et harum quo.
At vero ea fugit provident velit voluptatem eligendi. Corporis porro quasi non quasi. Nostrum aspernatur quo repudiandae consectetur impedit quis architecto. In qui illum eveniet dolor accusantium dicta repudiandae.
Doloribus sequi ab laboriosam architecto provident voluptas. Et asperiores voluptates necessitatibus ducimus. Doloribus ut expedita consectetur ab dolores quia beatae. Id ullam est sit odit sed corporis iusto deleniti. Voluptas architecto sed quam fuga facilis quia. Eaque dolorum earum maiores odit ea.
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...