Home
Videos uploaded by user “Sam Finance Tech”
Linear Regression for Evaluation: R
 
01:55
360 degree review is a common method used to feedback from colleagues so to evaluate employees for that Pay Rise or Promotion. But how do you reduce personal bias from the collected data? Simple linear regression can infer further information to us & may reduce some form of bias behavior. #RScript here : load in the excel data set under "Import Dataset" inputdata = read_excel("C:/data.xlsx") summary(inputdata) data_lm = lm(Y_Score_ByManager ~ X_Value_ByStaff, data=inputdata) print(data_lm) print("::::Apply Simple Linear Regress::::") predict(data_lm, inputdata) plot(Y_Score_ByManager ~ X_Value_ByStaff, main="Staff Review vs Manager Review", col.main="blue", data=inputdata) abline(data_lm, col="blue")
Views: 658 Sam Finance Tech
What is S.M.A.R.T Framework?
 
01:46
Are you been given any unrealistic targets by your boss or client? Sweeping statements makes you feel frustrated. You may be a hard-working and dedicated but whats the point if it cannot be measured objectively by all parties? I will introduce you to the SMART Framework for setting KPI: Specific = Singular objective. Measurable = Quantitative. Action = Tools or methods. Relevant = Beneficiary / Benefit. Time = Completion Dates. This framework makes the KPI clearer & allow you to track the progress more objectively with your clients or boss.
Views: 669 Sam Finance Tech
Business Review - Square Inc
 
01:35
In this video i am looking into Square Inc. Their technology is a hybrid of in store Payment Processing & Point Of Sales systems.
Views: 568 Sam Finance Tech
What is Invoice Financing?
 
01:24
0:12 Applications of Crowdfunding 0:30 Loans of Crowdfunding Platform 0:35 Loans Specs Overview 0:50 What is Invoice Financing 0:56 Breakdown of Fees & Costs 1:06 Business Accounting Journal Crowdfunding platform providers mainly has three types of loans: - Fast Loans, you can get it within hours but with highest interest cost. - Terms Loan, you can get it within days and with higher interest rate. - Invoice Financing, has lowest interest cost and with a loan up to 80%. Showing you how to use Invoicing financing and what will be the charges & fees breakdown for all parties. Also i will be showing you a simple accounting journal for such loan operation.
Views: 455 Sam Finance Tech
Hedge via T-Bills for your Business
 
01:44
Beside using T-Bills for short term gains, you can use it for tactical reasons in business, like Forex fluctuation risk reduction. Example: Your business is in South Korean & import goods from the US which months later you need to pay the invoice amount in USD. With this method, you would have protected yourself from future FOREX fluctuations.
Views: 623 Sam Finance Tech
Investors 5 Pre Qualifying Questions
 
01:37
Sharing with you a simple 5 Questions Checklist to Pre-Qualify crowdfunding investment before you even think of getting in any further. Hope it will help you....
Views: 617 Sam Finance Tech
Forex Quotes via JSON: PHP
 
01:17
As a currency dealer you will display your FX quotes to clients but without wanting them to have direct access to your server. A simple idea would be placing the price quotes in a separate JSON file whereby clients can draw data from it using PHP. %!-- This is php server file as main.php [email protected] %!DOCTYPE [email protected] %html lang="en"@ %[email protected] %[email protected] Server%/[email protected] %meta charset="utf-8"@ %meta name="viewport" content="width=device-width, initial-scale=1"@ %link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"@ %script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"@%/[email protected] %script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"@%/[email protected] %/[email protected] %[email protected] %div class="container"@ %div class="jumbotron"@ %[email protected] Forex Buy/Sell Rate%/[email protected] %/[email protected] %/[email protected] %div class="container"@ %?php $path = 'data.json'; $data = file_get_contents($path); $characters = json_decode($data); [email protected] %img src="1.jpg" class="img-thumbnail" alt="img" width="400" height="200"@ %[email protected] Quotes - SAM Xchange:%/[email protected]%[email protected] %table class="table table-hover"@ %[email protected] %[email protected] %th style="color:blue;"@%font size="5"@Product:%/[email protected]%/[email protected] %th style="color:blue;"@%font size="5"@Bid:%/[email protected]%/[email protected] %th style="color:blue;"@%font size="5"@Ask:%/[email protected]%/[email protected] %/[email protected] %/[email protected] %[email protected] %[email protected] %?php foreach ($characters as $i) : [email protected] %[email protected] %[email protected] %font size="4"%/[email protected] %?php echo [email protected]; [email protected] %/[email protected] %[email protected] %font size="4"%/[email protected] %?php echo [email protected]; [email protected] %/[email protected] %[email protected] %font size="4"%/[email protected] %?php echo [email protected]; [email protected] %/[email protected] %/[email protected] %?php endforeach; [email protected] %/[email protected] %/[email protected] %/[email protected] %/[email protected] %/[email protected] //Below is the data.json file// [ { "product": "USD/EUR", "Bid": "0.92", "Ask": "0.87" }, { "product": "USD/GBP", "Bid": "0.81", "Ask": "0.76" }, { "product": "USD/YEN", "Bid": "117", "Ask": "111" }, { "product": "USD/CHF", "Bid": "1.09", "Ask": "1.03" }, { "product": "USD/CAD", "Bid": "1.35", "Ask": "1.30" } ]
Views: 551 Sam Finance Tech
The Future for Startup Firms
 
01:32
0:00 My thoughts on WeWork 0:10 The WeWork Founders 0:17 Workspace Amenities 0:24 Indication of Invested Expertise 0:26 Tenants Selection Types 0:31 My Question to You 0:38 Short WeWork Office Video Tour This week, I been to a few co-sharing work space but i feel WeWork is one of the best so far. Their two founders had a vision of a collaborative entrepreneur environment for the startup community. WeWork invest in all areas, from lighting design to communication technology. I think that's why they are one of the best in the co-sharing workspace business. Tenants can select from hot desks to dedicated workspace. What do you think of co-sharing workspace as the Future for Startup Firms? Do you think it will also affect the future of commercial properties? Music: www.Bensound.com
Views: 380 Sam Finance Tech
Business Review - Snap Inc
 
01:14
This week i am looking at Snap Inc. The Augmented Reality software company on their Q2 - 2018 results. I love their interactive technology in mobile VR arena. Snap lenses & story board combination for advertising method.
Views: 501 Sam Finance Tech
What is a Pip?: Forex
 
01:54
Do you often hear this "Pip" term? Here's a simple explanation on Pip and calculating your returns, with FOREX trading example using IQ Option. Share your views in the comments section. Thanks
Views: 100 Sam Finance Tech
Forex Scalping Trade - USD/SGD
 
02:20
Is the currency moving at a premium that is above its nominal rate? Here's a simple explanation on Forward Premium Concept with trading example using IQ Option. Share your views in the comments section. Thanks
Views: 115 Sam Finance Tech
Encrypting Your Text: C#
 
01:01
Are you protecting your confidential data? This is a simple Text Encryption using AES in C# for finance personnel. //C# VS 2010 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Security.Cryptography; using System.IO; namespace WindowsFormsApp1 { public partial class Form1 : Form { string key = "SomeUniqueKey"; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { } private void button1_Click(object sender, EventArgs e) { try { byte[] bytesBuff = Encoding.Unicode.GetBytes(tb_data.Text); using (Aes aes = Aes.Create()) { Rfc2898DeriveBytes crypto = new Rfc2898DeriveBytes(key, new byte[] { 0x4d, 0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76 }); aes.Key = crypto.GetBytes(32); aes.IV = crypto.GetBytes(16); using (MemoryStream mStream = new MemoryStream()) { using (CryptoStream cStream = new CryptoStream(mStream, aes.CreateEncryptor(), CryptoStreamMode.Write)) { cStream.Write(bytesBuff, 0, bytesBuff.Length); cStream.Close(); } string gobble = Convert.ToBase64String(mStream.ToArray()); tb_data.Text = gobble; } } } catch (Exception ex) { MessageBox.Show("Text Box data cannot be empty. \n\n" + ex); } } private void button2_Click(object sender, EventArgs e) { try { byte[] bytesBuff = Convert.FromBase64String(tb_data.Text); using (Aes aes = Aes.Create()) { Rfc2898DeriveBytes crypto = new Rfc2898DeriveBytes(key, new byte[] { 0x4d, 0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76 }); aes.Key = crypto.GetBytes(32); aes.IV = crypto.GetBytes(16); using (MemoryStream mStream = new MemoryStream()) { using (CryptoStream cStream = new CryptoStream(mStream, aes.CreateDecryptor(), CryptoStreamMode.Write)) { cStream.Write(bytesBuff, 0, bytesBuff.Length); cStream.Close(); } string decrypt = Encoding.Unicode.GetString(mStream.ToArray()); tb_data.Text = decrypt; } } } catch (Exception ex) { MessageBox.Show("You need to execute Encrypt text first. \n\n" + ex); } } } }
Views: 474 Sam Finance Tech
FX Simultaneous Trade - USD/CHF
 
02:04
If you want to know the correlation of 2 currency pairs and how they move together, Pearson's R is an easy measure. Here's a simple explanation of Pearson's R Correlation, with FX trading example using IQ Option. Share your views in the comments section. Thanks
Views: 130 Sam Finance Tech
Human Capital Qualitative Measurement
 
02:04
Current education systems forces narrow career decisions in early years. Therefore skills deployment in the workplace becomes limited. So now the big question is, what Human Capital index are better measures for the future? WEF suggest in the future, it should be: - capacity to collaborate, - innovate, - self-direct, - problem-solve. A separate report by WIPO, they based their measures on: - Institution, - Knowledge & Technology Output, - Market & Business Sophistication.
Views: 613 Sam Finance Tech
Fast Mobile WebPage: AMP
 
01:16
Property Brokers spends quite a bit of money for hi-res images and videos. You do not want slow page load time and lose your customers. Here's an alternative solution in using Accelerated Mobile Page (AMP). @!doctype html% @html amp lang="en"% @head% @meta charset="utf-8"% @script async src="https://cdn.ampproject.org/v0.js"%@/script% @script async custom-element="amp-social-share" src="https://cdn.ampproject.org/v0/amp-social-share-0.1.js"%@/script% @script async custom-element="amp-video" src="https://cdn.ampproject.org/v0/amp- video-0.1.js"%@/script% @link rel="canonical" href="amptest.html"% @meta name="viewport" content="width=device-width, minimum-scale=1, initial-scale=1"% @title%Real Estate [email protected]/title% @style amp-custom% .fontHead { font-family: Arial Nova; color: Black; font-size: 24px; padding-top: 20px; padding-bottom: 20px; padding-left: 10px; } .fontBody { font-family: Arial Nova; color: Black; font-size: 13px; padding-top: 20px; padding-bottom: 20px; padding-left: 10px; } input[type=text], select, textarea { width: 100%; padding: 5px; border: 1px solid #ucc; border-radius: 5px; resize: vertical; } .padding { padding-left: 10px; padding-top: 5px; } .images { max-width: 100%; padding-left: 5px; } input[type=submit] { background-color: #4CAF50; color: white; padding: 15px 20px; border: none; border-radius: 8px; cursor: pointer; float: right; } @/style% @div class="fontHead"%Real Estate Listings using Accelerated Mobile [email protected]/div% @/head% @body% @div class="padding"% @amp-social-share class="rounded" type="whatsapp" width="31" height="31" data-param-text="Check Page Out: https://www.youtube.com/channel/UCZ0hLav- JVetCwt9hc9k5Hw" data-param-attribution="AMPhtml"% @/amp-social-share% @amp-social-share class="rounded" type="twitter" width="31" height="31"%@/amp-social-share% @amp-social-share class="rounded" type="email" width="31" height="31"% @/div% @/amp-social-share% @div class="fontBody"%ID#12345 Beach Hut Living at Beach Santiago. [email protected]/div% @div class="images"% @amp-img src="1.jpg" width="640" height="360" layout="responsive"% @/amp-img% @div class="padding"% @a href="1.mp4"% @amp-img class="home-button" src="camlink.jpg" width="75" height="25"% @/amp-img%@/a% @/div% @div class="fontBody"%ID#67891 Amazing Beach Front Private Suite at Coast Pine Seville. [email protected]/div% @div class="images"% @amp-img src="2.jpg" width="640" height="360" layout="responsive"% @/amp-img% @div class="padding"% @a href="2.mp4"% @amp-img class="home-button" src="camlink.jpg" width="75" height="25"% @/amp-img%@/a% @/div% @div class="fontBody"%ID#98765 Downtown Marina Boulevard. [email protected]/div% @div class="images"% @amp-img src="3.jpg" width="640" height="360" layout="responsive"% @/amp-img% @div class="padding"% @a href="3.mp4"% @amp-img class="home-button" src="camlink.jpg" width="75" height="25"% @/amp-img%@/a% @/div% @div class="fontBody"%Contact [email protected]/div% @div class="container"% @form action="server.php" method="get"% @label for="fname"%First [email protected]/label% @input type="text" id="fname" name="firstname" placeholder="How do we address you?..."% @label for="subject"%[email protected]/label% @textarea id="subject" name="subject" placeholder="Post your message here..." style="height:200px"%@/textarea% @input type="submit" value="Submit"% @/form% @/div% @br%@br%@br% @/body% @/html% @!-- this is the server.php file --% @!doctype html% @html amp lang="en"% @head% @meta charset="utf-8"% @script async src="https://cdn.ampproject.org/v0.js"%@/script% @link rel="canonical" href="server.php"% @title%Action [email protected]/title% @meta name="viewport" content="width=device-width, minimum-scale=1, initial-scale=1"% @style amp-custom% .fontHead { font-family: Arial Nova; color: Black; font-size: 38px; padding-top: 10px; padding-bottom: 20px; padding-left: 20px; } @/style% @div class="fontHead"%We will contact you shortly. Thank [email protected]/div% @div class="images"% @amp-img src="s1.jpg" width="200" height="100" layout="responsive"% @/amp-img%@/div% @/head% @body% @br% @br% Your Name: @?php echo $_GET["firstname"]; ?%@br% Your Message: @?php echo $_GET["subject"]; ?% @br% @/body% @/html%
Views: 419 Sam Finance Tech
Forex Cross Rates - USD/SGD/HKD
 
01:01
Sometimes we need a quick way to find the 3rd currency FX rates. Here's a simple explanation on calculating Forex Currency Cross Rates. If you have a better method, do share it in the comments section. Thanks. Check out my playlist on segmented videos for easy viewing.
Views: 132 Sam Finance Tech
Image Carousel For Finance Kiosk: JQuery
 
01:17
Create a simple image carousel webpage in kiosk device for your local finance events using BootStrap & JQuery. @html lang="en"? @head? @title?Sam Finance Concepts - Image Carousel [email protected]/title? @meta charset="utf-8"? @meta name="viewport" content="width=device-width, initial-scale=1", shrink-to-fit=no"? @link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css"? @script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"[email protected]/script? @script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"[email protected]/script? @script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"[email protected]/script? @style? .carousel-inner img { width: 100%; height: 75%; } @/style? @/head? @body? @nav class="navbar navbar-expand-lg navbar-light bg-light"? @div class="collapse navbar-collapse" id="navbarSupportedContent"? @ul class="navbar-nav mr-auto"? @li class="nav-item active"? @a class="nav-link" href="#"?Home @span class="sr-only"?(current)@/[email protected]/a? @/li? @/ul? @/div? @/nav? @div class="container mt-3"? @h1 class="display-4"?Create Image Carousel Webpage for Finance [email protected]/h1? @div id="img_caro" class="carousel slide"? @ul class="carousel-indicators"? @li class="item1 active"[email protected]/li? @li class="item2"[email protected]/li? @li class="item3"[email protected]/li? @/ul? @div class="carousel-inner"? @div class="carousel-item active"? @img src="1.jpg" width="1000" height="400"? @div class="carousel-caption"? @h1?Investor Talk [email protected]/h1? @p?The future [email protected]/p? @/[email protected]/div? @div class="carousel-item"? @img src="2.jpg" width="1000" height="400"? @div class="carousel-caption"? @h1?CFA after [email protected]/h1? @p?The best [email protected]/p? @/[email protected]/div? @div class="carousel-item"? @img src="3.jpg" width="1000" height="400"? @div class="carousel-caption"? @h1?CPA after [email protected]/h1? @p?The future [email protected]/p? @/[email protected]/div? @a class="carousel-control-prev" href="#img_caro"? @span class="carousel-control-prev-icon"[email protected]/span? @/a? @a class="carousel-control-next" href="#img_caro"? @span class="carousel-control-next-icon"[email protected]/span? @/a? @/div? @/div? @div class="jumbotron jumbotron-fluid"? @div class="container"? @h1 class="display-4"?CFA [email protected]/h1? @p class="lead"?Event topic on Par Value and evaluation [email protected]/p? @hr class="my-3"? @p?Get access to methods of par valuation and evaluation by industry experts. Hedge Funds managers share their knowledge with you on how to protect your assets. Lead by industry players pushing new [email protected]/p? @p?Event Date at 1st Dec [email protected]/p? @/div? @script? $(document).ready(function() { $(".carousel-control-prev").click(function() { $("#img_caro").carousel("prev"); }); $(".carousel-control-next").click(function() { $("#img_caro").carousel("next"); }); }); @/script? @/body? @/html?
Views: 396 Sam Finance Tech
The most Convex Bond?: JavaScript
 
01:43
Goldman Sachs (17/28) one of the most convex A+ bonds? Enter trade when market interest rate is at 6% for max yield? @!DOCTYPE html? @html? @head? @meta charset="UTF-8"? @meta name="description" content="Sam Finance Concepts"? @meta name="keywords" content="Sam Finance Concepts"? @meta name="author" content="Sam Finance Concepts"? @meta name="viewport" content="width=device-width, initial-scale=1.0"? @[email protected]/title? @h1 style="font-size:60px; background-color:lightgrey;" [email protected]/h1? @style? body {background-color: lightgrey;} h1 {color: black; margin-left: 40px;} .center { margin: auto; width: 80%; border: 4px solid #73AD21; padding: 20px; } h2 {color: green; margin-left: 40px; text-align: center; } input[type=text] { width: 100%; padding: 12px 20px; margin: 8px 0; box-sizing: border-box; } .button { background-color: #4CAF50; border: none; color: white; padding: 15px 32px; text-align: center; text-decoration: none; display: inline-block; font-size: 16px; margin: 4px 2px; cursor: pointer; } @/style? @/head? @body? @div class="center"? @form? @font size="6"?Year1 IR% :@/[email protected]? @input type="text" style="font-size:18pt" id="y1" /? @hr? @br? @font size="6"?FinalYear IR% :@/[email protected]? @input type="text" style="font-size:18pt" id="fy" /? @hr? @br? @font size="6"?Total Years between :@/[email protected]? @input type="text" style="font-size:18pt" id="ty" /? @hr? @br? @input type="button" class="button" onClick="f_compound()" value="Calculate" /? @/form? @/div? @script? function f_compound() { y1 = document.getElementById("y1").value; fy = document.getElementById("fy").value; ty = document.getElementById("ty").value; if(isNaN(y1 && fy && ty)) { alert("Please input numbers only"); } else { ex = (1 / (ty - 1)); document.getElementById("result").innerHTML = (Math.pow((Math.pow((1+(fy / 100)),ty)) / (1 + (y1 / 100)), ex) - 1) * 100; } } @/script? @h2?The Approx annual Forward Rate - discrete %: @[email protected]? @span id = "result"[email protected]/span? @/h2? @/body? @/html?
Views: 276 Sam Finance Tech
Filterable Web Table: BootStrap
 
01:10
Create a simple Web Data Table for Financial Service using BootStrap CSS. @html lang="en"? @head? @title?Create Web Data Table for Finance [email protected]/title? @meta charset="utf-8"? @meta name="keywords" content="Sam Finance Concepts"? @meta name="author" content="Sam Finance Concepts"? @meta name="viewport" content="width=device-width, initial-scale=1"? @link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css"? @script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"[email protected]/script? @script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"[email protected]/script? @script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"[email protected]/script? @/head? @body? @div class="container"? @h4 class="display-4"?Web Data Table for Finance [email protected]/h4? @div class="container mt-3"? @div class="card img-fluid" style="width:420px"? @img class="card-img-top" src="A.jpg" alt="Card image" style="width:120%"? @div class="card-img-overlay"? @h4 class="text-white"?Connect [email protected]/h4? @h4 class="text-white"?The Finance Managers [email protected]/h4? @/[email protected]/[email protected]? @div class="container mt-3"? @h3?Types of Finance Services [email protected]/h3? @input class="form-control" id="xytable" type="text" placeholder="Search by Name or Interested Service..."? @br? @table class="table table-bordered"? @thead? @tr? @th?Name:@/th? @th?Service:@/th? @th?Price:@/th? @th?Contact:@/th? @/tr? @/thead? @tbody id="xytable"? @tr? @[email protected]/td? @[email protected]/td? @[email protected]/td? @[email protected]@/td? @/tr? @tr? @[email protected]/td? @[email protected]/td? @[email protected]/td? @[email protected]@/td? @/tr? @tr? @[email protected]/td? @td?Trading [email protected]/td? @[email protected]/td? @[email protected]@/td? @/tr? @tr? @[email protected]/td? @[email protected]/td? @[email protected]/td? @[email protected]@/td? @/tr? @tr? @[email protected]/td? @td?Value [email protected]/td? @[email protected]/td? @[email protected]@/td? @/tr? @tr? @[email protected]/td? @td?Accounting [email protected]/td? @[email protected]/td? @[email protected]@/td? @/tr? @/tbody? @/table? @/div? @/div? @script? $(document).ready(function(){ $("#xytable").on("keyup", function() { var value = $(this).val().toLowerCase(); $("#xytable tr").filter(function() { $(this).toggle($(this).text().toLowerCase().indexOf(value) ? -1) }); }); }); @/script? @[email protected]? @ul class="pagination"? @li class="page-item disabled"[email protected] class="page-link" href="#"[email protected]/[email protected]/li? @li class="page-item"[email protected] class="page-link" href="#"[email protected]/[email protected]/li? @li class="page-item"[email protected] class="page-link" href="#"[email protected]/[email protected]/li? @/[email protected]/[email protected]/[email protected]/html?
Views: 336 Sam Finance Tech
Business Review - Wix.com
 
01:11
This week i am looking at Wix.com, the web commerce software company on their Q2 - 2018 results, while their Q3 earnings report will soon be out. So far, the Wix team has done quite a good job for a SaaS e-commerce firm.
Views: 478 Sam Finance Tech
Chance Of Lottery Strike?
 
01:21
Ever wonder what's the Chance of Striking Lottery? Here's an example using Dependent Event Probability. Share your views in the comments section. Thanks
Views: 141 Sam Finance Tech
Reading Forex Currency Quotes USD/EUR
 
00:57
Simple Explanation on Reading Forex Currency Pair. Conversion between the FX pairs. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 132 Sam Finance Tech
Contact Page for Client Manager: PHP
 
01:05
Recently i happen to walk into one of my customer shop but i forgotten his name, so i thought it would be nice to access a Name Deck so here's my simple idea on PHP/MYSQL in AMP for customer name deck creation. @!-- ServerClear.php page. Create a DB "myDB" in MYSQL server first [No need create table]. Thereafter run this page to drop & create DB + table --% @!doctype html% @html amp lang="en"% @head% @meta charset="utf-8"% @script async src="https://cdn.ampproject.org/v0.js"%@/script% @link rel="canonical" href="serverClear.php"% @title%Server Clear [email protected]/title% @meta name="viewport" content="width=device-width, minimum-scale=1, initial-scale=1"% @style amp-custom% .fontHead { font-family: Arial Nova; color: Black; font-size: 38px; padding-top: 10px; padding-bottom: 20px; padding-left: 20px; } table, th, td { border: 2px solid black; border-collapse: collapse; } th, td { padding: 10px; text-align: left; } @/style% @div class="fontHead"%Clear all Name Deck Data in [email protected]/div% @div class="images"% @amp-img src="sClear.jpg" width="50" height="10" layout="responsive"% @/amp-img% @/div% @/head% @body% @div class="fontHead"%Status Of DB Clear & Press Back to [email protected]/div% @br% @?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "myDB"; $conn = new mysqli($servername, $username, $password); if ($conn-%connect_error) { die("Connection failed: " . $conn-%connect_error); } else { $sql = 'DROP DATABASE myDB'; if ($conn-%query($sql) === TRUE) { echo "@font size=5%@table%@tr%@td%1) Database Drop [email protected]/td%@/tr%@/table%@/font%@br%"; $sql = "CREATE DATABASE myDB"; if ($conn-%query($sql) === TRUE) { echo "@font size=5%@table%@tr%@td%2) New Database Created [email protected]/td%@/tr%@/table%@/font%@br%"; $conn_t = new mysqli($servername, $username, $password, $dbname); $sql_t = "CREATE TABLE salesdata ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) NOT NULL, industry VARCHAR(30) NOT NULL, message VARCHAR(50) NOT NULL, reg_date TIMESTAMP )"; if ($conn_t-%query($sql_t) === TRUE) { echo "@font size=5%@table%@tr%@td%3) Table SalesData created [email protected]/td%@/tr%@/table%@/font%"; } else { echo "Error creating table: \n" . $conn_t-%error; } } else { echo "Error creating database: \n" . $conn-%error; } } } $conn-%close(); $conn_t-%close(); ?% @br%@br%@br%@br% @/body% @/html% @!-- ServerAdd.php page --% @!doctype html% @html amp lang="en"% @head% @meta charset="utf-8"% @script async src="https://cdn.ampproject.org/v0.js"%@/script% @link rel="canonical" href="serveradd.php"% @title%ServerAdd [email protected]/title% @meta name="viewport" content="width=device-width, minimum-scale=1, initial-scale=1"% @style amp-custom% .fontHead { font-family: Arial Nova; color: Black; font-size: 38px; padding-top: 10px; padding-bottom: 20px; padding-left: 20px; } @/style% @div class="fontHead"%Name Deck Creation:@/div% @div class="images"% @amp-img src="sAdd.jpg" width="50" height="12" layout="responsive"% @/amp-img%@/div% @/head% @body% @div class="fontHead"%DB Update Status:@/div% @br% @?php $name = $_GET["name"]; $ind = $_GET["ind"]; $msg = $_GET["msg"]; $servername = "localhost"; $username = "root"; $password = ""; $dbname = "myDB"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn-%connect_error) { die("Connection failed: " . $conn-%connect_error); } $sql = "INSERT INTO salesdata (name, industry, message) VALUES ('$name', '$ind', '$msg')"; if ($conn-%query($sql) === TRUE) { echo "@font size=5%New Record Created successfully:@/font%"; } else { echo "Error: " . $sql . "@br%" . $conn-%error; } $sql = "SELECT id, name, industry, message, reg_date FROM salesdata"; $result = $conn-%query($sql); if ($result-%num_rows % 0) { while($row = $result-%fetch_assoc()) { echo "@br%@br%@li%SN: " .$row["id"]. "@/li%"; echo "@li%Customer Name: " .$row["name"]. "@/li%"; echo "@li%Industry: " .$row["industry"]. "@/li%"; echo "@li%Message: " .$row["message"]. "@/li%"; echo "@li%Date: " .$row["reg_date"]. "@/ul%"; } } else { echo "0 results"; } $conn-%close(); ?% @br%@br%@br%@br% @/body% @/html%
Views: 417 Sam Finance Tech
Feliz Navidad to my YouTube Friends
 
01:03
Merry Christmas to all my YouTube friends. As its the holidays so i decided to dig out my Ukulele, which i had not touched for many years and play a short song. Pardon my wrong pronunciation & bad singing. Haha...Hope you had a good laugh. I do not have the right recording equipment so i overlay the singing & strumming thus there is a lag.
Views: 703 Sam Finance Tech
Retailers Mobile Payment Overview
 
01:18
I am going to give you an overview flow on mobile payment system, the role of financial acquirers & how your funds are routed after consumer scan a QR code for payment at your shop.
Views: 631 Sam Finance Tech
Task Allocator for Team: AngularJS
 
01:01
Recently i am thinking of how to create a Central Team Task Allocating List so that everyone in the team will know, who's doing what for the day. Therefore here's a simple AngularJS script for the idea. @!DOCTYPE html% @html% @head% @meta name="viewport" content="width=device-width, initial-scale=1"% @link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"% @script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"%@/script% @script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.6.9/angular.min.js"%@/script% @/head% @style% .button { background-color: #a0a0a0; border: none; color: white; padding: 12px; text-align: center; display: inline-block; font-size: 14px; margin: 4px 2px; cursor: pointer; border-radius: 30%; } .background { background-color: #f4f2f2; color: #111111; } @/style% @div class="container-fluid"% @h2%Team Task [email protected]/h2% @body ng-app="tasklist" ng-controller="ncontroller"% @img src="1.jpg" class="img-responsive" width="500" height="300"% @br% @p%@em%Note that Page Refresh will clear all [email protected]/em%@/p% @form ng-submit="f_add()"% @textarea ng-model="m_textarea" cols="60" rows="5" placeholder="List Task Here"%@/textarea%@br% @button type="submit" class="button"%Type & Add New [email protected]/button% @/form%@br% @div ng-repeat="i in repeater"% @br% @div class="container-fluid background"% @b%@p%Select Task Owner:@/p%@/b% @select ng-model="selectedName" ng-options="x for x in names"%@/select% @div ng-switch on= selectedName% @div ng-switch-when="All Members"%@em%This Task is for ALL:@/em%@/div% @div ng-switch-when="Becks"%@em%This Task is for Becks Only:@/em%@/div% @div ng-switch-when="Charles"%@em%This Task is for Charles Only:@/em%@/div% @button ng-click="f_remove()" class="button"%Tick & Click to Finish [email protected]/button% @input type="checkbox" ng-model="i.checked"% @/div% @span ng-bind="i.nbind"%@/span% @/div%@/div% @br%@br% @script% var start_angular = angular.module('tasklist', []); start_angular.controller('ncontroller', function($scope) { $scope.names = ["All Members", "Becks", "Charles"]; $scope.selectedName = "All Members"; $scope.repeater = []; $scope.f_add = function() { $scope.repeater.push({nbind:$scope.m_textarea, checked:false}); $scope.m_textarea = ""; }; $scope.f_remove = function() { var data_in_iterator = $scope.repeater; $scope.repeater = []; angular.forEach(data_in_iterator, function(i) {if (!i.checked) $scope.repeater.push(i); }); }; }); @/script% @/div% @/body% @/html%
Views: 503 Sam Finance Tech
Forex Triangular Arbitrage - USD/YEN/SGD
 
01:29
Ever wondered if you can make a profit through FX conversion? This is a simple explanation on the Concept of FOREX Triangular Arbitrage. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 138 Sam Finance Tech
Arithmetic Of Bond Duration: R
 
01:46
Simple explanation on Macualay Duration. FV = 1000000 market_ir = (0.08 / 2) coupon_rate = 0.1 coupon = ((coupon_rate / 2) * FV) last_coupon = FV + coupon coupon_payout = c(0,0,0) pv_xperiod = c(0,0,0) exponent = 0 counter = 0 repeat { counter = counter + 1 coupon_payout[counter] = coupon * (1+market_ir)^(exponent-1) pv_xperiod[counter] = coupon_payout[counter] * counter exponent = exponent - 1 if(counter==3) break } coupon_sum = sum(coupon_payout[1:3]) period_sum = sum(pv_xperiod[1:3]) PV_total = coupon_sum + (last_coupon * (1+market_ir)^-4) xperiod_total = period_sum + ((last_coupon * (1+market_ir)^-4) * 4) duration = (xperiod_total / PV_total) / 2 print(duration)
Views: 139 Sam Finance Tech
R Square of MSFT / S&P500
 
01:39
If you want to find out the correlation of a share to an index, R Square is one way of measuring. A simple explanation in applying R Square with example using Microsoft share & the S&P 500. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 116 Sam Finance Tech
Blog Creation for Fund Managers: BootStrap
 
01:09
Easy creating a web blog for fund managers informing their services using BootStrap CSS. @html lang="en"? @head? @title?Sam Finance Concepts - Web Blog For Fund [email protected]/title? @meta charset="utf-8"? @meta name="keywords" content="Sam Finance Concepts"? @meta name="author" content="Sam Finance Concepts"? @meta name="viewport" content="width=device-width, initial-scale=1"? @link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css"? @script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"[email protected]/script? @script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"[email protected]/script? @script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"[email protected]/script? @/head? @body? @div class="container"? @h2 class="display-3"?Create WebBlog for Fund [email protected]/h2? @div class="container mt-4"? @div class="card img-fluid" style="width:480px"? @img class="card-img-top" src="A.jpg" alt="Card image" style="width:180%"? @div class="card-img-overlay"? @h4 class="text-white"?Quantitative Finance For [email protected]/h4? @p class="text-white"?31-Aug-2018: Quant Finance Data Lessons By John [email protected]/p? @a href="next.html" class="btn btn-primary" target="_blank"?Read [email protected]/[email protected]/div? @/[email protected]? @div class="card img-fluid" style="width:480px"? @img class="card-img-top" src="B.jpg" alt="Card image" style="width:180%"? @div class="card-img-overlay"? @h4 class="text-black"?Ratio [email protected]/h4? @p class="text-black"?31-Aug-2018: Ratio Analysis Methods By Ana [email protected]/p? @a href="next.html" class="btn btn-primary" target="_blank"?Read [email protected]/[email protected]/[email protected]/[email protected][email protected]? @ul class="pagination"? @li class="page-item disabled"[email protected] class="page-link" href="#"[email protected]/[email protected]/li? @li class="page-item"[email protected] class="page-link" href="blogpage.html"[email protected]/[email protected]/li? @li class="page-item"[email protected] class="page-link" href="next.html"[email protected]/[email protected]/[email protected]/[email protected]/[email protected]/[email protected]/html?
Views: 274 Sam Finance Tech
Dell - Highly Leverage Business?: R
 
01:22
Dell Inc has the highest Coupon Bond at 6% for BB+ rating? Data analysis using R. price = c(110.89, 111.27, 111.43, 110.65, 109.91, 109.4, 107.06, 106.49, 106.97, 105.1, 105.23, 105.55) g_range = range(price) plot(price, type="o", col="blue", ylim=g_range, axes=FALSE, ann=FALSE) title(main="Average Ask Price", col.main="black", font.main=3) title(xlab="Months") title(ylab="Price") box() axis(1, at=1:12, lab=c("Aug 17","Sep 17","Oct 17","Nov 17","Dec 17", "Jan 18", "Feb 18", "Mar 18", "Apr 18", "May 18", "Jun 18", "Jul 18")) axis(2, las=1, at=1*0:g_range[2])
Views: 270 Sam Finance Tech
Apple Inc (16/36) Bond - Safe?: R
 
01:13
What do you think of the 20 years Apple 2016 issued bonds? Data Analysis using R. f_price_value = function (pa_coupon, FV, ir, years_left) { coupon = ((pa_coupon / 100) / 2) * FV cash_at_maturity = coupon + FV m = (ir / 100) / 2 n = (years_left * 2) price = (coupon * ((1-(1 + m)^-n) / m)) + (FV * (1 + m)^-n) value = c(price, cash_at_maturity, coupon) return(value) } f_ytm_value = function (FV, coupon, ir) { last = FV+coupon payout = c(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,1,2,3,4,5,6,7,8,9,50,11,12,13,14,15,16,17,18,19,60,1,2,3,4,5,6,7,8,9,70,71) exponent = -35.5 counter = 0 repeat { counter = counter + 1 payout[counter] = coupon * (1+ir)^(exponent) exponent = exponent + 0.5 if(counter==71) break } ytm = sum(payout[1:71]) + last*(1+ir)^-36 return(ytm) } y = f_ytm_value(100000, r1[3], 0.044231) r1 = f_price_value(4.5, 100000, 4.0809, 18) message("Coupon Payout of this bond $", round(r1[3], digit=0)) message("Last Payout value $", round(y, digit=0)) message("YTM% of this bond is 4.423%")
Views: 255 Sam Finance Tech
Buying Corp Bonds & Your YTM: R
 
02:35
Buying bond instruments and your YTM using SAXO Capital platform. Data Analysis using R. f_price_value = function (pa_coupon, FV, ir, years_left) { coupon = ((pa_coupon / 100) / 2) * FV cash_at_maturity = coupon + FV m = (ir / 100) / 2 n = (years_left * 2) price = (coupon * ((1-(1 + m)^-n) / m)) + (FV * (1 + m)^-n) value = c(price, cash_at_maturity, coupon) return(value) } f_ytm_value = function (FV, coupon, ir) { last = FV+coupon payout = c(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39) exponent = -19.5 counter = 0 repeat { counter = counter + 1 payout[counter] = coupon * (1+ir)^(exponent) exponent = exponent + 0.5 if(counter==39) break #0.5 x 39 = 19.5 } ytm = sum(payout[1:39]) + last*(1+ir)^-20 return(ytm) } y = f_ytm_value(100000, r1[3], 0.034463) r1 = f_price_value(3.54, 100000, 4.0809, 10) message("Coupon Payout of this bond $", round(r1[3], digit=0)) message("YTM in value $", round(y, digit=0)) message("YTM% of this bond 3.45%") message("Value of bond at Present $", round(r1[1], digit=0))
Views: 223 Sam Finance Tech
Android T-Bills Project: Java
 
01:05
I got a recent request to build a T-Bills price calculator for Android Mobile Device. Here is a simple version. Have fun... This is activity_main.xml: &?xml version="1.0" encoding="utf-8"?~ &android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" tools:context="com.example.activity.simpletbillcalc.MainActivity"~ &TextView android:id="@+id/textView" android:layout_width="368dp" android:layout_height="wrap_content" android:text="Maturity Value $:" android:textAppearance="@style/TextAppearance.AppCompat" app:layout_constraintBottom_toTopOf="@+id/et_mv" app:layout_constraintTop_toTopOf="parent" tools:layout_editor_absoluteX="8dp" /~ &EditText android:id="@+id/et_mv" android:layout_width="368dp" android:layout_height="wrap_content" android:ems="10" android:inputType="textPersonName" android:text="97000" app:layout_constraintBottom_toTopOf="@+id/textView2" app:layout_constraintTop_toBottomOf="@+id/textView" tools:layout_editor_absoluteX="8dp" /~ &TextView android:id="@+id/textView2" android:layout_width="368dp" android:layout_height="wrap_content" android:text="Interest pa% :" android:textAppearance="@style/TextAppearance.AppCompat" app:layout_constraintBottom_toTopOf="@+id/et_interest" app:layout_constraintTop_toBottomOf="@+id/et_mv" tools:layout_editor_absoluteX="8dp" /~ &EditText android:id="@+id/et_interest" android:layout_width="368dp" android:layout_height="wrap_content" android:ems="10" android:inputType="textPersonName" android:text="9.75" app:layout_constraintBottom_toTopOf="@+id/textView3" app:layout_constraintTop_toBottomOf="@+id/textView2" tools:layout_editor_absoluteX="8dp" /~ &TextView android:id="@+id/textView3" android:layout_width="368dp" android:layout_height="wrap_content" android:text="Days to Maturity :" android:textAppearance="@style/TextAppearance.AppCompat" app:layout_constraintBottom_toTopOf="@+id/et_days" app:layout_constraintTop_toBottomOf="@+id/et_interest" tools:layout_editor_absoluteX="8dp" /~ &EditText android:id="@+id/et_days" android:layout_width="368dp" android:layout_height="wrap_content" android:ems="10" android:inputType="textPersonName" android:text="150" app:layout_constraintBottom_toTopOf="@+id/bt_calc_b" app:layout_constraintTop_toBottomOf="@+id/textView3" tools:layout_editor_absoluteX="8dp" /~ &Button android:id="@+id/bt_calc_b" android:layout_width="368dp" android:layout_height="wrap_content" android:onClick="onClick" android:text="Calculate" app:layout_constraintBottom_toTopOf="@+id/tv_results" app:layout_constraintTop_toBottomOf="@+id/et_days" tools:layout_editor_absoluteX="8dp" /~ &TextView android:id="@+id/tv_results" android:layout_width="368dp" android:layout_height="wrap_content" android:text="Purchase Price of this T-Bills $: " android:textAppearance="@style/TextAppearance.AppCompat.Display1" app:layout_constraintBottom_toBottomOf="parent" app:layout_constraintTop_toBottomOf="@+id/bt_calc_b" tools:layout_editor_absoluteX="8dp" /~ &/android.support.constraint.ConstraintLayout~
Views: 637 Sam Finance Tech
Project Evaluation using NPV
 
01:07
Sometimes NPV looks too plain to be useful, however if you combine with WACC, it certainly becomes more useful. Here's a Simple explanation on applying NPV for finance. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 101 Sam Finance Tech
Expected Market Return Rate via CAPM
 
01:28
Want to get an idea of the investor's rate of return? Here's a simple explaination in applying CAPM. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 106 Sam Finance Tech
Beta For Shares - Realistic?
 
02:05
The idea of Beta seems abstract but it does has its application. Here's simple explanation on beta and its concept. Using Facebook stock price as example. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 103 Sam Finance Tech
Reading FX Dealer Quotes - USD/IDR/SGD
 
02:00
Reading Currency dealer quotes, sometimes gets confusing. Here's a simple explanation on Reading Currency Dealer Buy/Sell Forex Rates. If you have a better way, do share it in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 89 Sam Finance Tech
Arithmetic Of Loan Amortization
 
01:28
Before taking a up bank loan for (e.g. Housing, Cars), you want to know how much is the monthly fixed payment. Here's a simple explanation on Loan Amortization method. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 107 Sam Finance Tech
Duration, Bond Value & IR Effect: R
 
02:07
Simple explanation on Bond value change. Data analysis using R. f_pv_total = function(FV, coupon_rate, market_ir) { semi_ir = ((market_ir / 100) / 2) coupon = (((coupon_rate / 100) / 2) * FV) coupon_payout = c(0,0,0) pv_xperiod = c(0,0,0) exponent = 0 counter = 0 last_coupon = FV + coupon repeat { counter = counter + 1 coupon_payout[counter] = coupon * (1+semi_ir)^(exponent-1) pv_xperiod[counter] = coupon_payout[counter] * counter exponent = exponent - 1 if(counter==3) break } coupon_sum = sum(coupon_payout[1:3]) period_sum = sum(pv_xperiod[1:3]) PV_total = coupon_sum + (last_coupon * (1+semi_ir)^-4) xperiod_total = period_sum + ((last_coupon * (1+semi_ir)^-4) * 4) duration = (xperiod_total / PV_total) / 2 results = c(duration, PV_total) return(results) } f_change = function(duration, market_ir_change, market_ir, PV_total) { change = -duration * ((market_ir_change / 100) / (1 + (market_ir / 100))) * PV_total return(change) } before = f_pv_total(1000000, 10 ,8) message("Duration Years before IR Change ", round(before[1], digit=2)) message("PV Total before IR Change $", round(before[2], digit=2)) after = f_pv_total(1000000, 10, 9) message("PV Total After IR Change $", round(after[2], digit=2)) cp = f_change(before[1], 1, 8, before[2]) message("Change in Asset Value per Price Asset Change $", round(cp, digit=2)) net = after[2] - before[2] message("Change in Asset Value if calculated against all PV cashflow $", round(net, digit=2)) error = net - cp message("The error differences $", round(error, digit=2))
Views: 154 Sam Finance Tech
Come Join Me At Chijmes Singapore
 
01:27
Happy New Year 2019, my Friends !!! May You Have a Wonderful Year Ahead...Giving you a short tour of Chijmes Singapore. Chijmes is the film site of the movie, Crazy Rich Asians. This place is the full of higher end restaurants and bars, which is a great place for gatherings. The Church commonly host weddings and events. Music from: www.bensound.com
Views: 604 Sam Finance Tech
WACC - Know Your Firm Average Cost
 
01:49
With so much costs involved in a business, it is good to know the average "cost" rate of a business, in order to reference an over & above benchmark. Here's a simple explanation to applying the concept of WACC or the Weighted Average Cost of Capital in Business Finance. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 100 Sam Finance Tech
Forex Nominal Exchange Rate?
 
01:13
Ever wondered what is the nominal FX rate of currency? Here's a simple explanation on finding the Theoretical Forex Rate. Share your views in the comments section. Thanks Check out my playlist on segmented videos for easy viewing.
Views: 80 Sam Finance Tech

Thuoc econazole nitrate 150 mg trazodone
Toprol xl 25 mg how does it work
Side effects of zocor 10mg
Bactrim f 160mg-800mg dosage
Etossuximida generico de crestor