Saturday, January 14, 2017
Life Lessons From 100-Plus-Year-Olds
Life Lessons From 100-Plus-Year-Olds: Here is some sound advice... "As a retired physician, I can honestly say that unless you are in a serious accident, your best chance of living to a ripe old age is to avoid doctors and hospitals and learn nutrition, herbal medicine and other forms of natural medicine unless you are fortunate enough to have a naturopathic physician available. Almost all drugs are toxic and are designed only to treat symptoms and not to cure anyone. Vaccines are highly dangerous, have never been adequately studied or proven to be effective, and have a poor risk/reward ratio. Most surgery is unnecessary and most textbooks of medicine are inaccurate and deceptive. Almost every disease is said to be idiopathic (without known cause) or genetic—although this is untrue. In short, our main stream medical system is hopelessly inept and/or corrupt. The treatment of cancer and degenerative diseases is a national scandal. The sooner you learn this, the better off you will be.” Dr. Allan Greenberg, MD, Dec. 24, 2002
Friday, January 13, 2017
Financial freedom early retirement: Live Portfolio Tracker
Financial freedom early retirement: Live Portfolio Tracker
Actual updating stock tracker using yahoo data
Actual updating stock tracker using yahoo data
Google Sheets Bloomberg import quotes - Investing Sidekick
How to monitor your portfolio with Google Docs - Investing Sidekick: If neither Yahoo or Google can provide the stock price you need then there are other ways to get stock prices. Any website can theoretically be called to get a price. The formula below for example will get the stock price from Bloomberg. This has the widest range of coverage that I have found.
=ImportXml(“http://www.bloomberg.com/quote/ARGO:LN”;”//div[@class=’price’]”)
Do this for each stock, putting the share prices in another column in the same row as the number of shares. If it doesn’t work, make sure you got the ticker from the same website (Yahoo/Google) as you are using in the formula.
=ImportXml(“http://www.bloomberg.com/quote/ARGO:LN”;”//div[@class=’price’]”)
Do this for each stock, putting the share prices in another column in the same row as the number of shares. If it doesn’t work, make sure you got the ticker from the same website (Yahoo/Google) as you are using in the formula.
Inserting quotes from finance.yahoo.com into OpenOffice Community Forum
[Solved] Inserting quotes from finance.yahoo.com into a cell (View topic) • Apache OpenOffice Community Forum: Solved] Inserting quotes from finance.yahoo.com into a cell
Post a reply
13 posts • Page 1 of 1
[Solved] Inserting quotes from finance.yahoo.com into a cell
by tjeanneret � Thu Dec 04, 2008 12:13 am
Hello Everybody,
I want to retrieve informations from yahoo finance and insert them into the appropriate cell in a Calc sheet. I have the format description for the query string (URL) that will return a .csv file from yahoo, for exemple http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a for the simplest form of the last price of Apple.
But I don't know how I can use this information and put it in place in my spreadsheet.
I use the "link to external data" menu. I can specify the URL in the top dialog. Then I , and Calc retrieves the data from Yahoo, opens the "Import" dialog box, show me the data received and ask me what kind of separator I want to use (!). I accept the default, and . But nothing happens after this point.
The "Link to external data" dialog never gives me a choice for a location where to put the data, and the OK button stays inactive.
I have not found a way to save the .csv file itself in order to process it later.
Could you help me ?
Thanks in advance,
Post a reply
13 posts • Page 1 of 1
[Solved] Inserting quotes from finance.yahoo.com into a cell
by tjeanneret � Thu Dec 04, 2008 12:13 am
Hello Everybody,
I want to retrieve informations from yahoo finance and insert them into the appropriate cell in a Calc sheet. I have the format description for the query string (URL) that will return a .csv file from yahoo, for exemple http://finance.yahoo.com/d/quotes.csv?s=AAPL&f=a for the simplest form of the last price of Apple.
But I don't know how I can use this information and put it in place in my spreadsheet.
I use the "link to external data" menu. I can specify the URL in the top dialog. Then I , and Calc retrieves the data from Yahoo, opens the "Import" dialog box, show me the data received and ask me what kind of separator I want to use (!). I accept the default, and . But nothing happens after this point.
The "Link to external data" dialog never gives me a choice for a location where to put the data, and the OK button stays inactive.
I have not found a way to save the .csv file itself in order to process it later.
Could you help me ?
Thanks in advance,
Import Yahoo info to google spreadsheets frm yahoo finance | dry⋅powder
5-minute stock screener w/ google spreadsheets & yahoo finance | dry⋅powder:
In this case Yahoo! Finance returns an RSS 2.0 feed in response to this request. You can subscribe to the request URL.
�Similarly, Yahoo! Finance’s lets you get all kinds of stock data back in a CSV file.
�The google docs function can work with the csv to build our screener.
�Here are some useful tags we can can specify to get what we’re after:
a Ask
k5 % Change from 52-W
a2 Average Daily Volume
l Last Trade with Time
a5 Ask Size l1 Last Trade (Price Only)
b Bid l2 High Limit
b2 Ask (RT) l3 Low Limit
b3 Bid (RT) m Day’s Range
b4 Book Value m2 Day’s Range (RT)
b6 Bid Size m3 50-Day MA
etc etc
In this case Yahoo! Finance returns an RSS 2.0 feed in response to this request. You can subscribe to the request URL.
�Similarly, Yahoo! Finance’s lets you get all kinds of stock data back in a CSV file.
�The google docs function can work with the csv to build our screener.
�Here are some useful tags we can can specify to get what we’re after:
a Ask
k5 % Change from 52-W
a2 Average Daily Volume
l Last Trade with Time
a5 Ask Size l1 Last Trade (Price Only)
b Bid l2 High Limit
b2 Ask (RT) l3 Low Limit
b3 Bid (RT) m Day’s Range
b4 Book Value m2 Day’s Range (RT)
b6 Bid Size m3 50-Day MA
etc etc
Downloading Stock Prices into Google Spreadsheet
Downloading Stock Prices into Google Spreadsheet
Another way of importing Yahoo stock info. (see red remark at bottom!
Another way of importing Yahoo stock info. (see red remark at bottom!
How to Download Stock Prices into Google Spreadsheets - Finance Train
How to Download Stock Prices into Google Spreadsheets - Finance Train: Using Yahoo Finance
You can also download the stock prices from Yahoo Finance. To do so, google spreadsheets come with a nifty function called IMPORTDATA that can be used to import data from a url in .csv/.tsv format.
To retrieve the price of Apple stock from Yahoo finance, type the following function in Google Spreadsheet:
=importdata(“http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=sl1d1t1c1ohgv&e=.csv”)
This will download all the information about the stock in the spreadsheet, including ticker name, last trade price, volume, etc.
If you wanted historical prices, you can format your URL as below:
http://real-chart.finance.yahoo.com/table.csv?s=AAPL&d=2&e=4&f=2015&g=d&a=11&b=12&c=2000&ignore=.csv
Below is a description of the parameters:
s=AAPL is the symbol, in this case AAPL.
a=11 is the start month (0 for Jan, 1 for Feb, 2 for Mar, etc.). In our example it is December.
b=12 is the start day of the month. In our example, it is 12th.
c=2000 specifies the start year. In our case it is 2000.
So, for the historical data, the start date is 12th December, 2000.
d=2 specifies the end month. In our case it is March.
e=4 specifies the end day of the month In our example it is 4th.
f=2014 specifies the end year. For us it is 2014.
g=w represents the frequency of the data returned. (d for daily, m for monthly, w for weekly). For us, it is daily.
I hope this information will help you manage your finances better.
You can also download the stock prices from Yahoo Finance. To do so, google spreadsheets come with a nifty function called IMPORTDATA that can be used to import data from a url in .csv/.tsv format.
To retrieve the price of Apple stock from Yahoo finance, type the following function in Google Spreadsheet:
=importdata(“http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=sl1d1t1c1ohgv&e=.csv”)
This will download all the information about the stock in the spreadsheet, including ticker name, last trade price, volume, etc.
If you wanted historical prices, you can format your URL as below:
http://real-chart.finance.yahoo.com/table.csv?s=AAPL&d=2&e=4&f=2015&g=d&a=11&b=12&c=2000&ignore=.csv
Below is a description of the parameters:
s=AAPL is the symbol, in this case AAPL.
a=11 is the start month (0 for Jan, 1 for Feb, 2 for Mar, etc.). In our example it is December.
b=12 is the start day of the month. In our example, it is 12th.
c=2000 specifies the start year. In our case it is 2000.
So, for the historical data, the start date is 12th December, 2000.
d=2 specifies the end month. In our case it is March.
e=4 specifies the end day of the month In our example it is 4th.
f=2014 specifies the end year. For us it is 2014.
g=w represents the frequency of the data returned. (d for daily, m for monthly, w for weekly). For us, it is daily.
I hope this information will help you manage your finances better.
(1) How do you import fundamental stock data from Yahoo into Google Sheets? - Quora
(1) How do you import fundamental stock data from Yahoo into Google Sheets? - Quora: Shannon Chan, Spreadsheet geek
Written Mar 30, 2015
Here's a list of formulas that can help you import live Yahoo finance data into google spreadsheet. All you need to do is input the stock's ticker into cell A1, copy and paste any of the formulas below into any other cell and you'll have neatly formatted stock data right in your spreadsheet.
For summary trading data:
=IMPORTHTML("http://finance.yahoo.com/q?s="& $A$1,"table",2)
=IMPORTHTML("http://finance.yahoo.com/q?s="& $B$1,"table",3)
For historical prices:
=IMPORTHTML("http://finance.yahoo.com/q/hp?s="&$A$1&" Historical Prices","table")
For Key statistics:
Valuation Measures
=IMPORTHTML("http://finance.yahoo.com/q/ks?s="& $A$1&" Key Statistics","table", 11)
Written Mar 30, 2015
Here's a list of formulas that can help you import live Yahoo finance data into google spreadsheet. All you need to do is input the stock's ticker into cell A1, copy and paste any of the formulas below into any other cell and you'll have neatly formatted stock data right in your spreadsheet.
For summary trading data:
=IMPORTHTML("http://finance.yahoo.com/q?s="& $A$1,"table",2)
=IMPORTHTML("http://finance.yahoo.com/q?s="& $B$1,"table",3)
For historical prices:
=IMPORTHTML("http://finance.yahoo.com/q/hp?s="&$A$1&" Historical Prices","table")
For Key statistics:
Valuation Measures
=IMPORTHTML("http://finance.yahoo.com/q/ks?s="& $A$1&" Key Statistics","table", 11)
(1) How do you import fundamental stock data from Yahoo into Google Sheets? - Quora
(1) How do you import fundamental stock data from Yahoo into Google Sheets? - Quora: Here's a list of formulas that can help you import live Yahoo finance data into google spreadsheet. All you need to do is input the stock's ticker into cell A1, copy and paste any of the formulas below into any other cell and you'll have neatly formatted stock data right in your spreadsheet.
For summary trading data:
=IMPORTHTML("http://finance.yahoo.com/q?s="& $A$1,"table",2)
=IMPORTHTML("http://finance.yahoo.com/q?s="& $B$1,"table",3)
For summary trading data:
=IMPORTHTML("http://finance.yahoo.com/q?s="& $A$1,"table",2)
=IMPORTHTML("http://finance.yahoo.com/q?s="& $B$1,"table",3)
blood pressure 200/100 medicine no reaction - Google Search
blood pressure 200/100 medicine no reaction - Google Search
http://patient.info/forums/discuss/i-know-its-was-amlodipine--15885
http://patient.info/forums/discuss/i-know-its-was-amlodipine--15885
Thursday, January 12, 2017
Let’s Review: Peegate @ AMERICAN DIGEST
Let’s Review: Peegate @ AMERICAN DIGEST
t seems they are trying to make the world believe in Trump and "Peegate."
Really? This seems to be the way Peegate worked:
1) An international business man who has spent decades in the rough and tumble world of real estate development and skyscraper construction and may be presumed to have some sophistication when it comes to wheeling and dealing with governments of all sorts throughout the world travels to
2) Moscow. Not Moscow, Idaho, but Moscow in Russia. That would be Moscow the capital of one of the most paranoid and intrusive governments in the world (Both now and for the 19th and 20th centuries.). It is a society and a government with a long history of...
3) Secret police and the clandestine surveillance of its own citizens and visitors to the extent that the US was digging bugs out of the walls of its own embassy in Moscow for decades. When he gets to Moscow he stays at...
4) The Moscow Ritz-Carlton in the “Presidential Suite.” Since such accommodations are typically only taken by the filthy rich and/or representatives of foreign governments such as, say, presidents. And then this sophisticated and reasonably intelligent billionaire real estate developer...
5) Assumes that such a suite in such a capitol city of such a government has no surveillance equipment at all installed in its rooms, bathrooms, closets, and -- most importantly -- bedrooms. He then asks the hotel staff to show him...
6) The bed in which Barack Obama and his wife slept in when they were in this same “Presidential Suite.” Upon being show the bed our businessman then...
7) Contacts two high-dollar Russian hookers (who would never, ever, have anything to do with the KGB or other intelligence organs of Russia) and instructs them to.... Wait for it....
8) Urinate on said bed in order to give said businessman some odd sort of thrill and...
9) Said businessman remains utterly positive no agency of the Russian state is running cameras and microphones from every possible angle in the master bedroom in a “Presidential Suite” in a top hotel in the capitol of Russia and...
10) The two damp hookers will never, ever, reveal a word about their golden shower in the Ritz Carleton’s “Presidential Suite.”
While I know that millions of morons are nodding like the drinking bird over the glass in their deep and abiding belief in this overflowing crock, I still find it hard to believe that there are smart people out there that really are this stupid. But of course they are not that stupid, not the smart ones. Instead they know this is a crock and yet they find they must drink from it
t seems they are trying to make the world believe in Trump and "Peegate."
Really? This seems to be the way Peegate worked:
1) An international business man who has spent decades in the rough and tumble world of real estate development and skyscraper construction and may be presumed to have some sophistication when it comes to wheeling and dealing with governments of all sorts throughout the world travels to
2) Moscow. Not Moscow, Idaho, but Moscow in Russia. That would be Moscow the capital of one of the most paranoid and intrusive governments in the world (Both now and for the 19th and 20th centuries.). It is a society and a government with a long history of...
3) Secret police and the clandestine surveillance of its own citizens and visitors to the extent that the US was digging bugs out of the walls of its own embassy in Moscow for decades. When he gets to Moscow he stays at...
4) The Moscow Ritz-Carlton in the “Presidential Suite.” Since such accommodations are typically only taken by the filthy rich and/or representatives of foreign governments such as, say, presidents. And then this sophisticated and reasonably intelligent billionaire real estate developer...
5) Assumes that such a suite in such a capitol city of such a government has no surveillance equipment at all installed in its rooms, bathrooms, closets, and -- most importantly -- bedrooms. He then asks the hotel staff to show him...
6) The bed in which Barack Obama and his wife slept in when they were in this same “Presidential Suite.” Upon being show the bed our businessman then...
7) Contacts two high-dollar Russian hookers (who would never, ever, have anything to do with the KGB or other intelligence organs of Russia) and instructs them to.... Wait for it....
8) Urinate on said bed in order to give said businessman some odd sort of thrill and...
9) Said businessman remains utterly positive no agency of the Russian state is running cameras and microphones from every possible angle in the master bedroom in a “Presidential Suite” in a top hotel in the capitol of Russia and...
10) The two damp hookers will never, ever, reveal a word about their golden shower in the Ritz Carleton’s “Presidential Suite.”
While I know that millions of morons are nodding like the drinking bird over the glass in their deep and abiding belief in this overflowing crock, I still find it hard to believe that there are smart people out there that really are this stupid. But of course they are not that stupid, not the smart ones. Instead they know this is a crock and yet they find they must drink from it
Wednesday, January 11, 2017
Is there a way to get real time stock quotes in a Google Spreadsheet? - Docs editors Help
Is there a way to get real time stock quotes in a Google Spreadsheet? - Docs editors Help: Is there a way to get real time stock quotes in a Google Spreadsheet?
Stock Quote issues - Google Product Forums
Stock Quote issues - Google Product Forums: Shasha - Community Specialist said:
Hi Philip,
Welcome to the Google Docs Help Forum.
As you mentioned, you're facing issues with some Canadian stocks. I'd recommend following the below steps to see if it helps:
Close the tab and reopen (Ctrl-Shift-T).
Select the cells with formulas, copy and paste back as "values only".
In addition to this, you can try using the IMPORTXML function that can pull the price off the google finance webpage. To learn more, please refer to our useful Help Center Article on�GOOGLEFINANCE.
If the issue still persists, please consider sharing a sample sheet with us using the shareable link.
Hope this helps.
Best,
Shasha
Hi Philip,
Welcome to the Google Docs Help Forum.
As you mentioned, you're facing issues with some Canadian stocks. I'd recommend following the below steps to see if it helps:
Close the tab and reopen (Ctrl-Shift-T).
Select the cells with formulas, copy and paste back as "values only".
In addition to this, you can try using the IMPORTXML function that can pull the price off the google finance webpage. To learn more, please refer to our useful Help Center Article on�GOOGLEFINANCE.
If the issue still persists, please consider sharing a sample sheet with us using the shareable link.
Hope this helps.
Best,
Shasha
Stock Quote issues - Google Product Forums
Stock Quote issues - Google Product Forums: 10/10/16
Shasha - Community Specialist said:
Hi Philip,
Thanks for writing back.
I'd recommend going through the stocks that doesn't work for you and use the ticker symbol located in parentheses after the stock name.�
For example:
STANDARD EXPLORATION LTD.(CVE:SDE):�https://www.google.com/finance?q=SDE.v&ei=RPj7V-mnH5K1iAKwmLvwBA
The formula would be =googlefinance("CVE:SDE")
You currently have it as SDE.v, which appears to be the issue.
Once this is corrected, if the data does not appear or appears incorrectly on�finance.google.com, you�can leave feedback with Google Finance by clicking "Report a problem" at the bottom of�finance.google.com.
Hope this helps.
Best,
Shasha
Shasha - Community Specialist said:
Hi Philip,
Thanks for writing back.
I'd recommend going through the stocks that doesn't work for you and use the ticker symbol located in parentheses after the stock name.�
For example:
STANDARD EXPLORATION LTD.(CVE:SDE):�https://www.google.com/finance?q=SDE.v&ei=RPj7V-mnH5K1iAKwmLvwBA
The formula would be =googlefinance("CVE:SDE")
You currently have it as SDE.v, which appears to be the issue.
Once this is corrected, if the data does not appear or appears incorrectly on�finance.google.com, you�can leave feedback with Google Finance by clicking "Report a problem" at the bottom of�finance.google.com.
Hope this helps.
Best,
Shasha
Monday, January 09, 2017
Subscribe to:
Posts (Atom)
