Friday, January 13, 2017

Vietnam Veterans Against John "Songbird" McCain - YouTube

Vietnam Veterans Against John "Songbird" McCain - YouTube

Sultan Knish: A Drought of Sanity in California

Sultan Knish: A Drought of Sanity in California

Financial freedom early retirement: Live Portfolio Tracker

Financial freedom early retirement: Live Portfolio Tracker

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.

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,

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

Downloading Stock Prices into Google Spreadsheet

Downloading Stock Prices into Google Spreadsheet



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.

(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)

(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)

Are your blood pressure pills not working? Blame your hormones | Daily Mail Online

Are your blood pressure pills not working? Blame your hormones | Daily Mail Online

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


Thursday, January 12, 2017

How to control your Galaxy S3 or S4 with your voice - AndroidPIT

How to control your Galaxy S3 or S4 with your voice - AndroidPIT

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

Wednesday, January 11, 2017

import xml - Google Search

import xml - Google Search

How to Scrape Data From the Web Using Google Spreadsheet - YouTube

How to Scrape Data From the Web Using Google Spreadsheet - YouTube

Is there a way to get real time stock quotes in a Google Spreadsheet? - Google Search

Is there a way to get real time stock quotes in a Google Spreadsheet? - Google Search

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

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

Wednesday, January 04, 2017

10 Times When Less Is More - Altucher Confidential

10 Times When Less Is More - Altucher Confidential: The MAXIMUM you need to learn to be good at 99% of things in life:

Math: basic probability and statistics that you can do in your head. For instance, know that 1/3 of 10,000 is 3,333 (roughly).

English: Learn how to read. Because later you might like reading and reading will make you a better writer.

Note that whenever you read a book, you might remember 1-2% of it. If you read lots of books that will add up. But no pressure to remember more.

History: A two page outline of the history of the planet. Because all the books are biased.

And then later they get rewritten.

Much later in life you might want to, for fun, explore those biases and read books about it.

Three good history books I think are worth reading:

“Sapiens”�by Yuval Noah Harari
“The Evolution of Everything” by Matt Ridley
“Wonderland” by Steve Johnson
Science: Nothing. You don’t even really need to know that the Earth is flat. If you want to be a scientist then learn more science.

Sometimes science is fun. I like reading science fiction.

Art: I don’t know. I never learned art. I’m only starting to appreciate it and read about it now. I’m 48.

In the past few weeks I went to The Broad museum in LA and The Whitney in NYC. Fascinating!

So now I am reading books to learn more. But I’ve never learned about art before because I had no interest.

If you try to teach people with no interest, they won’t learn.

To this day, at every conference I speak at, nobody can tell me the birthdate of Charlemagne within 500 years.

Go ahead, guess right now!

Saturday, December 31, 2016

Petroleum Industry | The Encyclopedia of Oklahoma History and Culture

Petroleum Industry | The Encyclopedia of Oklahoma History and Culture: Large pockets of high-pressure natural gas and huge oil production characterized Oklahoma City. One well, the Number One McBeth, had a daily flow of 101,002 barrels of oil

Petroleum Industry | The Encyclopedia of Oklahoma History and Culture

Petroleum Industry | The Encyclopedia of Oklahoma History and Culture: Also in 1906 the final Osage roll of 2,229 tribal members was completed. Tribal land was allotted, but mineral rights were held in common. Each member was entitled to one Osage headright, or one equal share of oil and natural gas royalty, and the money poured in. On one afternoon in 1924 Walters sold $10,888,000 worth of leases, with a single 160-acre lease bringing $1,990,000. Such huge wealth occasioned an "Osage Reign of Terror," a series of crimes in which Osage headright holders were swindled and sometimes murdered for their share of royalty money

History of EARLY OIL in OKLAHOMA

Tuesday, December 27, 2016

Never Yet Melted

Never Yet Melted: From Lisa Schiffren on Facebook:

A Tourist walked into a Chinese curio shop in San Francisco . While looking around at the exotic merchandise, he noticed a very lifelike, life-sized, bronze statue of a rat. It had no price tag, but was so incredibly striking the tourist decided he must have it. He took it to the old shop owner and asked, “How much for the bronze rat ?”

“Ahhh, you have chosen wisely! It is $12 for the rat and $100 for the story,” said the wise old Chinaman.

The tourist quickly pulled out twelve dollars. “I’ll just take the rat, you can keep the story”.

As he walked down the street carrying his bronze rat, the tourist noticed that a few real rats had crawled out of the alleys and sewers and had begun following him down the street. This was a bit disconcerting so he began walking faster.

A couple blocks later he looked behind him and saw to his horror the herd of rats behind him had grown to hundreds, and they began squealing.

Sweating now, the tourist began to trot toward San Francisco Bay.

Again, after a couple blocks, he looked around only to discover that the rats now numbered in the MILLIONS, and were squealing and coming toward him faster and faster.

Terrified, he ran to the edge of the Bay and threw the bronze rat as far as he could into the Bay.

Amazingly, the millions of rats all jumped into the Bay after the bronze rat and were all drowned.

The man walked back to the curio shop in Chinatown.

“Ahhh,” said the owner, “You come back for story?”

“No sir,” said the man, “I came back to see if you have a bronze Democrat.

Sunday, December 25, 2016

AMERICAN DIGEST: Comment on "No one was on the look-out for a divine interference,"

AMERICAN DIGEST: Comment on "No one was on the look-out for a divine interference,": Everything changed that day. Everything.

Merry Christmas, Gerard!

Posted by Joan of Argghh at December 25, 2011 5:27 AM
Of course it was a silent night. They were all too astonished to speak.

Tuesday, December 13, 2016

Rex Tillerson: Eagle Scout @ AMERICAN DIGEST

Rex Tillerson: Eagle Scout @ AMERICAN DIGEST

AMERICAN DIGEST: Comment on Within Living Memory: Norming the Perverted

AMERICAN DIGEST: Comment on Within Living Memory: Norming the Perverted: "In a sort of ghastly simplicity we remove the organ and demand the function. We make men without chests and expect of them virtue and enterprise. We laugh at honour and are shocked to find traitors in our midst. We castrate and bid the geldings be fruitful.”
― C.S. Lewis, The Abolition of Man

Sunday, December 11, 2016

The Immaculate Conception Explained - YouTube

The Immaculate Conception Explained - YouTube

Mary was saved by Jesus

As Al Gore Told Donald Trump . . . - HappyAcres

As Al Gore Told Donald Trump . . . - HappyAcres: Green handouts have become a political end in themselves.

Over its lifecycle, an electric car will generate just 23% fewer greenhouse gas emissions than a gasoline-powered car. If every car on earth were electric, this translates into a mere 1.8% decline in total emissions.

Yet even a small electric car will cost its owner $20,816 more to own and operate than a comparable gas-powered car, and its total “human toxicity”—mainly due to heavy metals and graphite—will be three to five times greater.

Electric cars

Inbox (3350) - Yahoo Mail

Inbox (3350) - Yahoo Mail

http://cmancali.tumblr.com/

Thursday, December 08, 2016

Great Global Warming Swindle - Al Gore Excerpt - YouTube

Great Global Warming Swindle - Al Gore Excerpt - YouTube

see comments

Great Global Warming Swindle - Al Gore Excerpt - YouTube

Great Global Warming Swindle - Al Gore Excerpt - YouTube

global warming

Dark Matter @ AMERICAN DIGEST - relativity

Dark Matter @ AMERICAN DIGEST

The Day We Killed John Lennon @ AMERICAN DIGEST

The Day We Killed John Lennon @ AMERICAN DIGEST

youtube grandfather

(3342 unread) - jdr1228 - Yahoo Mail

Why Donald Trump May Never Pay Federal Income Tax Again | Investopedia

Why Donald Trump May Never Pay Federal Income Tax Again | Investopedia

This Is How Donald Trump Actually Got Rich | Investopedia

This Is How Donald Trump Actually Got Rich | Investopedia

Danielle DiMartino Booth on the Trump Federal Reserve | Investopedia

Danielle DiMartino Booth on the Trump Federal Reserve | Investopedia

Horse bonds with Seeing Eye camel in Winslow | WGME

Horse bonds with Seeing Eye camel in Winslow | WGME

Take a deep breath...inhaling through nose stimulates brain and boosts memory

Take a deep breath...inhaling through nose stimulates brain and boosts memory

Texting Abbreviations

Texting Abbreviations

Friday, December 02, 2016

Electotial College

AMERICAN DIGEST Essays, News, Notes, and Quotes: Our presidential election system has, in effect, 51 elections--
46 states, four Commonwealths, and one District of Columbia.
Each one of those "little" elections has electors assigned to it equal to the number of representatives it has in both houses of Congress; each state (in general) grants it electors to the winning candidate within its boundaries. Since we currently have 538 members in that Congress, a winning candidate needs 270 electoral votes to win. The idea of the now much-maligned electoral college is to serve as part of the intricate system of checks-and-balances that this really, really smart Brits instituted to avoid tyrannies by either a minority OR by a majority. Everybody gets a voice, regardless of whether they are big or little. Dear progs, please look at the UN that you love so much: every country there gets the same vote regardless of size: Luxembourg gets the same vote as China. Should we change that? The DiploMad 2.0: Tough Times to be a Progressive

Tuesday, November 29, 2016

John Lewis Christmas Advert 2016 - #BusterTheBoxer - YouTube

John Lewis Christmas Advert 2016 - #BusterTheBoxer - YouTube

John Lewis Christmas Advert 2016 - #BusterTheBoxer - YouTube

John Lewis Christmas Advert 2016 - #BusterTheBoxer - YouTube

Pancho said sing!

Pancho said sing!

AMERICAN DIGEST Essays, News, Notes, and Quotes

AMERICAN DIGEST Essays, News, Notes, and Quotes: China today is extraordinarily homogenous.
It sustains that by remaining almost entirely closed to new entrants except by birth. Unless someone is the child of a Chinese national, no matter how long they live there, how much money they make or tax they pay, it is virtually impossible to become a citizen. Someone who marries a Chinese person can theoretically gain citizenship; in practice few do. As a result, the most populous nation on Earth has only 1,448 naturalised Chinese in total, according to the 2010 census.Even Japan, better known for hostility to immigration, naturalises around 10,000 new citizens each year; in America the figure is some 700,000 The upper Han | The Economist

http://www.economist.com/news/briefing/21710264-worlds-rising-superpower-has-particular-vision-ethnicity-and-nationhood-has http://www.economist.com/news/briefing/21710264-worlds-rising-superpower-has-particular-vision-ethnicity-and-nationhood-has

Sunday, November 27, 2016

mustard for leg cramps - Google Search

mustard for leg cramps - Google Search: Football players and other athletes are sometimes told by their coaches to swallow a few spoons of mustard to fight off leg cramps. One reason mustard may be effective for this purpose is because the condiment contains acetic acid (in vinegar), which prompts the body to produce more acetylcholine

Shin and Foot Cramping Over Night - Sciatica, Leg Pain, Radiculopathy

Shin and Foot Cramping Over Night - Sciatica, Leg Pain, Radiculopathy: I have suffered on and off with critically low potassium and have had to take prescription supplements to correct this. You might want to ask your GP to run a basic blood panel just to be sure.

Aside from bananas, which most people think of as a good source of potassium, orange juice is also a good source. If your market carries them (and you like them), avacados are an excellent source of potassium too.

It's a pretty simple thing to check your blood potassium, and it may point to the cause of your muscle cramps. I'd urge you to talk to your GP about that before assuming that your cramps are due to your psoriatic arthitis.

Shin and Foot Cramping Over Night - Sciatica, Leg Pain, Radiculopathy

Shin and Foot Cramping Over Night - Sciatica, Leg Pain, Radiculopathy: I have suffered on and off with critically low potassium and have had to take prescription supplements to correct this. You might want to ask your GP to run a basic blood panel just to be sure.

Aside from bananas, which most people think of as a good source of potassium, orange juice is also a good source. If your market carries them (and you like them), avacados are an excellent source of potassium too.

It's a pretty simple thing to check your blood potassium, and it may point to the cause of your muscle cramps. I'd urge you to talk to your GP about that before assuming that your cramps are due to your psoriatic arthitis.