Skip to content

Instantly share code, notes, and snippets.

@chintanparikh
Last active August 29, 2015 14:05
Show Gist options
  • Save chintanparikh/1b1421db27f9c970fe2b to your computer and use it in GitHub Desktop.
Save chintanparikh/1b1421db27f9c970fe2b to your computer and use it in GitHub Desktop.
{
"BBRY" => {
"Qtrly Rev Growth" => {
"datapoint" =>"Qtrly Rev Growth (yoy)",
"data" =>"-0.69"
},
"Revenue" => {
"datapoint" =>"Revenue (ttm)",
"data" =>"4.71B"
},
"Gross Margin (ttm)" => {
"datapoint" =>"Gross Margin (ttm)",
"data" =>"-0.11"
},
"EBITDA" => {
"datapoint" =>"EBITDA (ttm)",
"data" =>"-2.36B"
},
"Operating Margin" => {
"datapoint" =>"Operating Margin (ttm)",
"data" =>"-0.73"
},
"Net Income" => {
"datapoint" =>"Net Income (ttm)",
"data" =>"-5.77B"
},
"EPS" => {
"datapoint" =>"EPS (ttm)",
"data" =>"-11.18"
},
"P/E" => {
"datapoint" =>"P/E (ttm)",
"data" =>"N/A"
},
"PEG" => {
"datapoint" =>"PEG (5 yr expected)",
"data" =>"-0.88"
},
"P/S" => {
"datapoint" =>"P/S",
"data" =>"0.42"
}
},
"GOOG" => {
"Qtrly Rev Growth" => {
"datapoint" =>"Qtrly Rev Growth (yoy)",
"data" =>"0.22"
},
"Revenue" => {
"datapoint" =>"Revenue (ttm)",
"data" =>"65.14B"
},
"Gross Margin (ttm)" => {
"datapoint" =>"Gross Margin (ttm)",
"data" =>"0.58"
},
"EBITDA" => {
"datapoint" =>"EBITDA (ttm)",
"data" =>"19.42B"
},
"Operating Margin" => {
"datapoint" =>"Operating Margin (ttm)",
"data" =>"0.23"
},
"Net Income" => {
"datapoint" =>"Net Income (ttm)",
"data" =>"13.05B"
},
"EPS" => {
"datapoint" =>"EPS (ttm)",
"data" =>"19.09"
},
"P/E" => {
"datapoint" =>"P/E",
"data" =>"30.27"
},
"PEG" => {
"datapoint" =>"PEG (5 yr expected)",
"data" =>"N/A"
},
"P/S" => {
"datapoint" =>"P/S",
"data" =>"6.00"
}
},
"HPQ" => {
"Qtrly Rev Growth" => {
"datapoint" =>"Qtrly Rev Growth (yoy)",
"data" =>"0.01"
},
"Revenue" => {
"datapoint" =>"Revenue (ttm)",
"data" =>"112.18B"
},
"Gross Margin (ttm)" => {
"datapoint" =>"Gross Margin (ttm)",
"data" =>"0.24"
},
"EBITDA" => {
"datapoint" =>"EBITDA (ttm)",
"data" =>"13.25B"
},
"Operating Margin" => {
"datapoint" =>"Operating Margin (ttm)",
"data" =>"0.08"
},
"Net Income" => {
"datapoint" =>"Net Income (ttm)",
"data" =>"5.10B"
},
"EPS" => {
"datapoint" =>"EPS (ttm)",
"data" =>"2.84"
},
"P/E" => {
"datapoint" =>"P/E",
"data" =>"14.28"
},
"PEG" => {
"datapoint" =>"PEG",
"data" =>"3.01"
},
"P/S" => {
"datapoint" =>"P/S",
"data" =>"0.63"
}
},
"AAPL" => {
"Qtrly Rev Growth" => {
"datapoint" =>"Qtrly Rev Growth (yoy)",
"data" =>"0.06"
},
"Revenue" => {
"datapoint" =>"Revenue (ttm)",
"data" =>"178.14B"
},
"Gross Margin (ttm)" => {
"datapoint" =>"Gross Margin (ttm)",
"data" =>"0.38"
},
"EBITDA" => {
"datapoint" =>"EBITDA (ttm)",
"data" =>"59.13B"
},
"Operating Margin" => {
"datapoint" =>"Operating Margin (ttm)",
"data" =>"0.29"
},
"Net Income" => {
"datapoint" =>"Net Income (ttm)",
"data" =>"38.56B"
},
"EPS" => {
"datapoint" =>"EPS (ttm)",
"data" =>"5.96"
},
"P/E" => {
"datapoint" =>"P/E",
"data" =>"16.30"
},
"PEG" => {
"datapoint" =>"PEG",
"data" =>"1.37"
},
"P/S" => {
"datapoint" =>"P/S",
"data" =>"3.39"
}
}
}
{
"Qtrly Rev Growth" => {
"BBRY" =>"-0.69",
"GOOG" =>"0.22",
"HPQ" =>"0.01",
"AAPL" =>"0.06"
},
"Revenue" => {
"BBRY" =>"4.71B",
"GOOG" =>"65.14B",
"HPQ" =>"112.18B",
"AAPL" =>"178.14B"
},
"Gross Margin (ttm)" => {
"BBRY" =>"-0.11",
"GOOG" =>"0.58",
"HPQ" =>"0.24",
"AAPL" =>"0.38"
},
"EBITDA" => {
"BBRY" =>"-2.36B",
"GOOG" =>"19.42B",
"HPQ" =>"13.25B",
"AAPL" =>"59.13B"
},
"Operating Margin" => {
"BBRY" =>"-0.73",
"GOOG" =>"0.23",
"HPQ" =>"0.08",
"AAPL" =>"0.29"
},
"Net Income" => {
"BBRY" =>"-5.77B",
"GOOG" =>"13.05B",
"HPQ" =>"5.10B",
"AAPL" =>"38.56B"
},
"EPS" => {
"BBRY" =>"-11.18",
"GOOG" =>"19.09",
"HPQ" =>"2.84",
"AAPL" =>"5.96"
},
"P/E" => {
"BBRY" =>"N/A",
"GOOG" =>"30.27",
"HPQ" =>"14.28",
"AAPL" =>"16.30"
},
"PEG" => {
"BBRY" =>"-0.88",
"GOOG" =>"N/A",
"HPQ" =>"3.01",
"AAPL" =>"1.37"
},
"P/S" => {
"BBRY" =>"0.42",
"GOOG" =>"6.00",
"HPQ" =>"0.63",
"AAPL" =>"3.39"
}
}
stocks = @valuation_data.keys
datapoints = @valuation_data[@valuation_data.keys[0]].keys
zipped = datapoints.map do |datapoint|
Hash[stocks.zip(stocks.map { |s| @valuation_data[s][datapoint]["data"] })]
end
transformed_data = Hash[datapoints.zip(zipped)]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment