Posts

AWS CLI - INSTALLATION AND CONFIGURATION

Image
AWS CLI - INSTALLATION AND CONFIGURATION https://aws.amazon.com/cli/ Download the MSI installer from here Install as administrator If you haven’t done that before then create your IAM credentials here Access Key ID: AXXXXXXXXXXXXXXXXXXXXQ Secret Access Key : FYYYYYYYYYYYYYYYYYYYYYYYYYYYY2i After the installation is successfully accomplished - open cmd and issue the following command aws configure aws /? Try sns sns /? To get the list of commands that for the sns system You could also use aws help and aws sns help Run the following command: aws sns list-topics

Windows 10 or Windows Server 2012 - Repair a Drive

Image
Windows 10 or Windows Server 2012  - Repair a Drive GO to troubleshooting CHoose - command prompt option Provide the password Use wmic logicaldisk get caption to list the drives (fdisk -l is not available anymore) Change the drive to C: Run chkdsk /SCAN /F Alternatively - mount the drive to another VM - the errors will be detected and fixed as soon as the system detects the new drive
Image
Azure - Setting up the Continuous Integration & Deployment - Azure DevOps - VSTS Navigate to visualstudio.com and click on the following  button: Hit Continue You should get a following confirmation email You will be redirected to the dashboard page https://dev.azure.com/extpiki/?acquisitionId=ca13fd28-53bb-4c63-b5d7-34e09d26e88b&product=suite Create a new project “pandora-items” New window opens: https://dev.azure.com/extpiki/pandora-items
Image
Azure Logic Apps - Consuming RESTService - Stock Quotes Navigate to https://www.alphavantage.co/ Get your API Key Test the connection https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=GE&interval=1min&apikey= YOURKEY Create a new LogicApp Add Recurrence as the first shape and configure it to trigger the application every 1 Minute Click on the New step -> Add an action Then search for Variables Initialize a new variable of type string named “LastRefreshed” to store the last refreshed value  that provided in the “Meta Data” section of the HTTP response for fetching required data from “Time Series (1min)” section *. Initialize another variable (repeat steps 6 and 7) of type float named “value” to store the “Open” value of the given Stock Option Add a new action of type HTTP (HTTP - HTTP) Specify the GET method in the first filed In the lower left corner switch from...

VBA Randomize a 3x3 Filter for Convoluted Neural Network

Image
EXCEL FOR FINANCE How to Randomize a 3x3 Filter for a Convoluted Neural Network in VBA Option Explicit Private Sub CommandButton1_Click()    Application.ScreenUpdating = False    Application.DisplayStatusBar = False     Dim i, j As Integer     Dim randomNumber As Double        For i = 1 To 3       Randomize                     For j = 1 To 3               randomNumber = rnd()                 'Application.ActiveWorkbook.ActiveSheet.Cells(i + 20, j + 29).Select                Application.ActiveWorkbook.Active...