InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,148.65
(
0.41%
)
US TECH 100
17,474.80
(
0.32%
)
Dow Jones
38,863.49
(
0.49%
)
Brent Oil
83.23
(
0.13%
)
Bitcoin
63,590.72
(
-0.64%
)
Post# of 47077
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Keep Next 10 Report Keyboard Shortcuts
Next 10 Prev Next

SFSecurity

Send PM Follow Ignore
Followers 2
Posts 1185
Boards Moderated 0
Alias Born 07/15/2014

SFSecurity

Re: None

Monday, 09/04/2017 4:09:19 PM

Monday, September 04, 2017 4:09:19 PM

Post# of 47077
Hi Gang, Well, duh, I feel a bit stupid for not figuring this out before but just like in Word, if you put a URL in a cell it will go there once you double click and confirm you want to do it.

Yeah, Yahoo loads the data into a separate spreadsheet so you have to copy and paste to get the data where you want it. But you can have a connection like: https://finance.yahoo.com/d/quotes.csv?s=(StockSymbol)+(StockSymbol)+(StockSymbol)&f=sd1t1l1vc1pn and get all the data you might want. You just have to chose what is in the last part from the charts I posed before and it's all there for you.

One click and you've got all your positions, prices, etc..

Best,

Allen
Public Reply Private Reply New Post
Keep Last Read
Keep Last Read Next 10 Report Keyboard Shortcuts
Next 10 Prev Next

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up