Home
Videos uploaded by user “Codible”
Calculating stock beta using Excel
 
04:29
Download the excel file here: https://codible.myshopify.com/products/excel-file-to-go-with-calculating-stock-beta-using-excel Description: How to calculate beta for a stock using Excel 2010. Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 338350 Codible
NPV and IRR in Excel 2010
 
09:00
Description: How to calculate net present value (NPV) and internal rate of return (IRR) in excel with a simple example. Download the excel file here: https://codible.myshopify.com/products/npv-and-irr-in-excel-2010-excel-files Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 902528 Codible
Codible SQLite video 1: How to install sqlite (SQLite3) on windows 10
 
04:31
Shows how to install the latest sqlite on Windows 10, and how to specify the sqlite folder path in the environment variables setting, so that you can run sqlite from any folder on windows. Best book on SQLite: http://amzn.to/2tNzOzW
Views: 54871 Codible
Getting started with sqlite on windows
 
04:57
Shows how to download sqlite, install on windows, create your first database and table, and insert a record into the table. Best book on SQLite: http://amzn.to/2tNzOzW
Views: 114730 Codible
Excel tutorial: calculating covariance and correlation of stock returns
 
08:00
Discusses how to download two companies' stock returns from Yahoo Finance, and calculate (a) the variance and standard deviation of each stock, and (b) the covariance and correlation of the returns of both stocks. Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 164673 Codible
Graphing the efficient frontier for a two-stock portfolio in Excel
 
12:23
Shows how to download returns for two stocks, calculate mean, variance and standard deviations for various portfolios of the two stocks, and draw the efficient frontier in Excel. Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 147738 Codible
get started with sqlite on mac.mp4
 
04:56
Shows how to get started creating a database using sqlite on a mac computer Follow us on twitter: https://twitter.com/codible
Views: 22341 Codible
Excel 2010: Buy versus lease calculation
 
04:43
Shows how to analyze the total cost of leasing versus buying, using Excel 2010. Follow us on twitter: https://twitter.com/codible Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 72458 Codible
Cash flow with multiple IRRs
 
05:51
Shows how multiple internal rates of return (IRR) can result when cash flows change sign more than once. When that happens, use Net Present Value (NPV).
Views: 31232 Codible
Basics of Hadoop Distributed File System (HDFS)
 
09:39
Describes how to view and create folders in HDFS, copy files from linux to HDFS, and copy files back from HDFS to linux.
Views: 33318 Codible
Stock returns: average, variance, and standard deviation
 
04:29
Shows how to download stock data from Yahoo Finance, and calculate daily stock returns, average stock returns, variance and standard deviation of stock returns Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 225747 Codible
Cash flow after deprecition and tax - 2: depreciation tax shield
 
02:33
This video explores the role of the depreciation tax shield in calculating cash flows. Follow us on Twitter: https://twitter.com/codible
Views: 27270 Codible
Excel tutorial: Creating hyperlinks in Excel 2010
 
02:46
Download excel file: http://codible.com/pages/62 Shows you how to create hyperlinks to different worksheets in your excel 2010 spreadsheet. This lets you quickly go to different worksheets by just a click on the hyperlink. Follow us on twitter: https://twitter.com/codible
Views: 70358 Codible
capital market line and sharpe ratio in excel
 
07:48
Download excel file: http://www.codible.com/pages/86 Compute Sharpe ratio using Excel Solver, to draw the capital market line and determine the optimal two-stock portfolio to combine with a risk-free asset. Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 58870 Codible
Create a pivot chart in Excel 2010
 
05:59
Download excel file: http://codible.com/pages/43 See how to create a pivot chart, add axis fields and legend fields, format the numbers to dollars, change the chart type from column to bar chart, change axis title, and add chart title. Follow us on twitter: https://twitter.com/codible
Views: 69914 Codible
calculating future value on excel
 
06:18
Demonstrates the concept of future value and shows how to use the FV function in Excel 2010 Follow us on twitter: https://twitter.com/codible Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 155311 Codible
Google spreadsheets - sum, average, if, and other functions
 
05:36
See how to use functions such as sum, average, if, count, min, and max on Google Spreadsheet. Follow us on twitter: https://twitter.com/codible
Views: 125445 Codible
python IDLE previous command
 
03:12
See how to pull up previous commands in Python IDLE, without having to type them again. Users of Unix, Linux and Windows command prompt will be familiar with the up- and down- arrows that pull up previous commands. In python, it is alt-p and alt-n. This video also shows how you can modify these keyboard shortcuts.
Views: 5081 Codible
stock returns regression in excel
 
09:24
Download excel file to go with video: http://www.codible.com/pages/84 Analyze stock price data using Microsoft Excel to plot returns, and plot a regression line between the stock returns. Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 84507 Codible
minimum variance portfolio
 
06:47
(Download excel file: http://www.codible.com/pages/85) Compute the minimum variance of a two-stock portfolio using Excel Solver. Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 60968 Codible
Creating a calculated field in your pivot table
 
05:27
Download excel file: http://codible.com/pages/42 In your pivot table, a calculated field lets you add, subtract, multiply, divide or otherwise combine existing fields in your table to create new fields. Follow us on twitter: https://twitter.com/codible
Views: 43208 Codible
Create a simple form using Ruby on Rails
 
06:47
Create a simple web form using Ruby on Rails Follow us on twitter: https://twitter.com/codible
Views: 41985 Codible
Hadoop: Use Sqoop to copy a relational database table to HDFS
 
05:34
Shows how to use the Sqoop tool to copy a table from a relational database such as MySQL, into the Hadoop distributed file system
Views: 6759 Codible
Create scenarios in excel 2010
 
06:18
Download excel file: http://codible.com/pages/47 Create best-case, worst-case and most likely scenarios quickly on excel 2010 Follow us on twitter: https://twitter.com/codible
Views: 15308 Codible
Apache Pig: Writing and running a simple script in Hadoop
 
10:41
Shows how you can use Apache Pig to read a text file from Hadoop, do some minimal processing, and dump the results to the screen, in a Linux environment.
Views: 26838 Codible
Excel tutorial: Monthly mortgage payments with Excel 2010
 
05:10
Download excel file: http://codible.com/pages/71 Calculate your monthly mortgage payments with Excel 2010, using the PMT function. Follow us on twitter: https://twitter.com/codible
Views: 5003 Codible
Discounting quarterly and mid-year cash flows
 
09:17
Typically NPV calculations assume that cash flows in at the end of each year. Here you can see how to compute NPV assuming quarterly cash flows or mid-year discounting.
Views: 10838 Codible
Use NPV to compare projects with different life spans
 
08:10
Shows the use of NPV and the equivalent annuity cash flow concept (EAC) to compare projects with different life spans
Views: 16215 Codible
SUMIF function on Excel 2010
 
05:16
Download excel file: http://codible.com/pages/48 SUMIF function lets you choose specific rows in your Excel table and sum their values. Follow us on twitter: https://twitter.com/codible
Views: 32748 Codible
Create a two-variable data table in Excel 2010
 
05:38
Download excel file: http://www.codible.com/pages/45 A two variable data table lets you perform what-if analysis by varying two variables to produce a table of what-if values for a given formula. Follow us on twitter: https://twitter.com/codible
Views: 55661 Codible
Excel tutorial: Present value (PV) in excel 2010
 
04:02
Download excel file: http://codible.com/pages/58 Present value (PV) function lets you calculate the present discounted value of a series of future cash flows. In this example we see how to calculate the loan amount you can borrow for a given series of equal monthly payments like, say a car loan payment. Follow us on twitter: https://twitter.com/codible Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 108834 Codible
Discount rate - 1: Weighted Average Cost of Capital using Excel
 
06:56
Describes how to calculate the weighted average cost of capital for a company, using its equity, debt, and tax rate, using Excel.
Views: 28704 Codible
Show pivot table values as percentages
 
05:28
Display numbers in your pivot table as a percentage of row totals, column totals, or grand total numbers. Download the excel file here: http://codible.com/pages/41 Follow us on twitter: https://twitter.com/codible
Views: 9816 Codible
Ruby on Rails one to many relationships - part 2
 
08:24
(Transcript available on http://www.codible.com/?p=16) How to create data models and forms featuring one to many relationships, using Ruby on Rails (part 1) Follow us on twitter: https://twitter.com/codible
Views: 6784 Codible
Auto financing: zero percent versus cash back
 
06:59
If you like this, try my Excel course on Udemy: https://www.udemy.com/fundamentals-of-excel-for-business/ Description: Shows a comparison of zero percent vs. cash back financing using Excel and IRR
Views: 1288 Codible
Pivot table - insert and format a slicer
 
04:54
See how to insert a slicer, which can help other users quickly and easily slice and dice your pivot table. Download the excel file here: http://codible.com/pages/40 Follow us on twitter: https://twitter.com/codible
Views: 47731 Codible
Compute cash flow after depreciation and tax
 
03:57
Shows how to calculate cash flow after depreciation and tax for a simple house-rental example using Excel 2013 Follow us on Twitter: https://twitter.com/codible
Views: 12341 Codible
Excel tutorial: Creating a loan amortization table in Excel 2010
 
04:44
Download excel file: http://www.codible.com/pages/59 When repaying a loan (e.g. car loan) with a fixed monthly payment, this video shows you how to detail the principal and interest components of the payments over the period of repayment. Follow us on twitter: https://twitter.com/codible Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 42180 Codible
Codible SQLite video 2: Quickly create a simple table in a database (SQLite3)
 
08:04
Shows you how to use SQLite to - create a table inside a database - create fields within the table - specify the data types and primary key - insert values into the table - see how the "primary key" constraint is enforced by SQLite - run queries to view the data you entered
Views: 4154 Codible
Gordon Dividend Model on Excel
 
10:34
Explains the Gordon Dividend Model and how to use it to calculate (a) today's price for a stock, and (b) the rate of return for a company's equity.
Views: 7089 Codible
Codible SQLite video 3: SQLite3 - how to create tables and upload csv data
 
06:56
Describes how to create tables in SQLite, how to upload data into the tables from CSV files, and how to remove the heading rows if they have been accidentally imported.
Views: 4440 Codible
Create a one-variable data table in Excel 2010
 
07:34
Download this excel file: http://www.codible.com/pages/44 Description: A data table lets you do what-if analysis by computing and displaying formulas for different values of a variable input.
Views: 126086 Codible
Adding chart title and axis-titles
 
03:24
Shows how to add titles to your chart, and to the x- and y- axes. Download excel file here: http://www.codible.com/pages/5 Follow us on twitter: https://twitter.com/codible
Views: 270632 Codible
AVERAGEIF function in Excel 2010
 
05:08
Download excel files: http://codible.com/pages/49 The AVERAGEIF function lets you compute the average of specific numbers in a table, based on a filter you specify. Follow us on twitter: https://twitter.com/codible
Views: 25311 Codible
Tutorial: how to write a simple ruby program on your mac.mp4
 
06:21
Shows you how to get started writing ruby programs on a mac using textedit to write your program, and terminal to run your program Follow us on twitter: https://twitter.com/codible
Views: 3253 Codible
lease-vs-purchase-with-taxes
 
09:27
This video demonstrates how to compare lease and purchase cash flows with tax implications
Views: 15754 Codible
Calculating median in Excel 2010
 
02:55
This short video demonstrates the concept of the median, and how to calculate the median in Excel 2010. Follow us on twitter: https://twitter.com/codible
Views: 40729 Codible
Ruby on Rails - One to many relationships part 1
 
08:49
(Transcript available on http://www.codible.com/?p=16) How to create data models and forms featuring one to many relationships, using Ruby on Rails (part 1) Follow us on twitter: https://twitter.com/codible
Views: 12629 Codible
Clustered columns chart in Excel
 
06:52
Download excel file here: http://www.codible.com/pages/8. Description: Shows how to create a chart with clustered columns in Excel 2010, delete rows or columns, and switch rows and columns. Also shows how to convert it to a stacked-columns chart, and add spark lines.
Views: 489027 Codible
Use goal-seek in Excel 2010
 
03:19
Download excel file: http://www.codible.com/pages/46 Description: The goal-seek feature lets you specify a goal- value in a formula, and excel will automatically find the appropriate input value to achieve this goal. Some good books on Excel and Finance: Financial Modeling - by Benninga: http://amzn.to/2tByGQ2 Principles of Finance with Excel - by Benninga: http://amzn.to/2uaCyo6
Views: 86682 Codible

The great gatsby music trailer from pride
How to dance electronic trap music youtube
Camille durand jazz music
Tablatures blues picking music
Dizzy dros cazafonia instrumental music youtube