userque's Account talk

Absolutely fascinating...I Robot coming up.. I hope the 3 Laws are hardwired into it.:D

BTW Q. Do you know of a macro that I can use in Excel that would open a browser, select a webpage, extraxt a specific piece of information (a number - for example Volume) and return it to the spreadsheet? I am working to build my own little home indicator spreadsheet but I don't want to do all the grunt work every day. Thanks.

FS
 
Absolutely fascinating...I Robot coming up.. I hope the 3 Laws are hardwired into it.:D

BTW Q. Do you know of a macro that I can use in Excel that would open a browser, select a webpage, extraxt a specific piece of information (a number - for example Volume) and return it to the spreadsheet? I am working to build my own little home indicator spreadsheet but I don't want to do all the grunt work every day. Thanks.

FS

The coolest thing about Excel is being able to Record macros. Press record, manually do exactly what you want to do, press stop. That's almost always you're best starting point. Then go and modify the macro so its more generic. I created exactly what you mentioned, but for fantasy football. I created a macro that would get the data for all of the current matchups for all my teams, import it into excel (Look at the Data tab, there is a 'From Web' option), account for duplicates, make a list of my players and my opponents, and put their current point totals.
 
The coolest thing about Excel is being able to Record macros. Press record, manually do exactly what you want to do, press stop. That's almost always you're best starting point. Then go and modify the macro so its more generic. I created exactly what you mentioned, but for fantasy football. I created a macro that would get the data for all of the current matchups for all my teams, import it into excel (Look at the Data tab, there is a 'From Web' option), account for duplicates, make a list of my players and my opponents, and put their current point totals.

Do you use solver to pick your players?
 
Absolutely fascinating...I Robot coming up.. I hope the 3 Laws are hardwired into it.:D

BTW Q. Do you know of a macro that I can use in Excel that would open a browser, select a webpage, extraxt a specific piece of information (a number - for example Volume) and return it to the spreadsheet? I am working to build my own little home indicator spreadsheet but I don't want to do all the grunt work every day. Thanks.

FS

If you only want quote data, and yahoo will do, you don't need to open any browsers or record macros or type vba code. You can use a little know excel function WEBSERVICE to put the data right in the cell where the function resides. I used to use it a lot. It updates the quote with each refresh of the sheet. These links should get you going:

How to: Obtain stock quotes from Yahoo finance in Excel - Everything about Technology

Slow Wealth: Fetching Stock Quotes with Excel 2013 and Windows 8

https://www.bogleheads.org/forum/viewtopic.php?t=151530

You may need at least excel 2013...not sure.
 
Thanks for the links. I used to use the MSN quote function with mixed results, then it stopped being supported entirely.

I just tried this and can't get it to work so far (I just get #NAME? in the cell, there must be something simple I'm doing wrong):
How to: Obtain stock quotes from Yahoo finance in Excel - Everything about Technology

This app is $89 for just stock quotes, but is tempting, looks really easy...
Live Stock Quotes in Excel - MarketXLS: Financial Tools for Investors

Maybe post your formula here. Also, I'll see if I can find one of my old sheets and check it out too.
 
Maybe post your formula here. Also, I'll see if I can find one of my old sheets and check it out too.

Worked for me: (If you want to use this, I'd copy/paste it as the 'L' and the '1' look similar.)

Code:
=NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s=^w4500&f=l1"))

Also, you have to do a special refresh to get it to update. Of course, it won't update while the markets are closed, but it is giving the proper closing value from Friday.
 
(VIDEO) Rise of the Robots--NOVA (click the link, not the image :) )
[video]http://www.pbs.org/video/2365670738/[/video]
rob.jpg
 
[h=1]Reading the tape. Level 2 quotes. No: stochastics, indicators, news, extra monitors, etc. Pure day-trading.

(VIDEO) Iceberg Orders and Market Manipulation:

[/h]
 
How the game works
When playing Chartgame, the computer will present you with a random historical stock chart of an actual large cap (S&P 500) security, without telling you which company and time period the chart represents.

You are then given the opportunity to reveal the stock chart one day at a time, selecting to "buy" or "sell" the stock at various times. After a maximum of one year is played for the security, the actual name of the company, and what time period the graph was for is revealed, and you move on to another stock chart for an unknown company and time period.

Chartgame.com - The time-lapse stock trading game

sample_chart_sm.png
 
The following link refers to a piece against traditional technical analysis. The authors beliefs are not necessarily my own. They are selling something, but who isn't?

"Technical Analysis Has Contributed To A Massive Wealth Redistribution


Classical technical analysis has contributed to the largest non-violent wealth-redistribution in the history of mankind. Modern technical analysis is not doing any better.

The massive wealth redistribution that was caused by the use of technical analysis was from retail traders to market makers, started in the 1980s and lasted for about three decades.

The redistribution is still continuing but it is limited and it is from technical traders that are experiencing a backfire cognitive bias to algo traders that act as market makers."


Technical Analysis Has Contributed To A Massive Wealth Redistribution | Price Action Lab Blog
 
Back
Top